Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Speeding up an Acces Database (http://www.go4expert.com/forums/speeding-acces-database-t21465/)

pbrydone 23Mar2010 18:12

Speeding up an Acces Database
 
1 Attachment(s)
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

apr pillai 21Feb2011 14:12

Re: Speeding up an Acces Database
 
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.

apr pillai 21Feb2011 14:15

Re: Speeding up an Acces Database
 
Quote:

Originally Posted by apr pillai (Post 79657)
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 http://www.go4expert.com/O12FileMenu...ZA10077102.gif, 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.


All times are GMT +5.5. The time now is 01:43.