Access database and application fixes and upgrades

An existing application written in Access 97 is starting to give problems. The database design is flawed probably, but I am not certain. The original design of this software was started in 1998 or so and has sort of grown in complexity over the years. The software is used to run a pie maker's daily production operations. The reports that are required take a long time to run and today started having errors and would not run at all. We need to fix the current errors asap and then start working on upgrading the software or rewriting it to fix the ongoing performance problems. ## Deliverables You may download the source code and error screen shots from [login to view URL] There is also included a login credentials document. The program to open is Inventory.mdb. The reports causing problems reported by the user: On Production system there is a report called Production Schedule (14d) and then under Purchasing the reports are Materials Drawdown (14d ALL) and Packaging Drawdown (12d). Please see the screen shots in the zip file for the error. You may also write me for questions or clarifications if needed.