It seems everyone has a horror story about MS Access
here's a doozy:
"McGillicutty Power and Light was a small utilities company with a big
problem: Their customer base was growing by leaps and bounds but the
supposed-to-be simple task of printing a batch of invoices was taking a
glacial age to complete. Things got to be so bad in fact that each of
the accounting clerks needed two PC's – one dedicated to everyday tasks
like email and spreadsheets and the other for printing invoices.
It wasn't as if the printing workstation was maxed-out on resources,
it's just that generating customer invoices was a delicate process. If
one were to, say, compose an email while printing invoices, then the
printer would be full of email print-outs instead of invoices, meaning
that the batch print would need to be run from scratch. Hired on as one
of the "big guns" to help address the grim situation, John Reese was not
surprised when he saw how the company's business "logic" was being executed.
Written in Microsoft Access, invoices were created by running a macro
that sent a complex series of "sendKey" commands to the UI that
simulated scrolling through the records and clicking the "Print Report"
button. This was not only time-consuming, but it was what made the
workstation off-limits to the user while the process was running. The
only thing missing was the duct tape..."