I have created an MS Access database primarily for tracking file movement. The database is a split database and has a front end which sits on client computers (about 10 computers) and a back end which sits on a Server 2003 server. The problem I am having is that the database runs too slow even with no more than 2 concurrent users. I have checked our etwork and can't spot any issues that culd slow things down. On a standalone non-split database it appears to run quite ok. The tracking number is scanned in via a bar code scanner and other fields are manually entered. Grateful for advice on how I can speed things up and also if anyone has some ideas on how to generate a search form. I have attached a non-split database in zipped fomat Many thanks
Run Repairing/Compacting untility at least once in a week. Take a Backup of the database before you run the above utility. You must have exclusive access and Administrative privilages to run the Repairing/Compacting utility.
Access2007: Click the Microsoft Office Button , point to Manage, and then, under Manage this database, click Compact and Repair Database In older versions you can find this option under Tools Menu.