Speeding up an Acces Database

pbrydone's Avatar, Join Date: Mar 2010
Newbie Member
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
Attached Files
File Type: zip Tracking.zip (385.0 KB, 24 views)
0
apr pillai's Avatar, Join Date: Dec 2010
Go4Expert Member
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.
0
apr pillai's Avatar, Join Date: Dec 2010
Go4Expert Member
Quote:
Originally Posted by apr pillai View Post
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.