access slow loading?

[penfold1992]

It may be that the computers used are slow but I am trying to improve the speed of the loading of a access database.

Is there any specifics that could make the database slower? anything specific in forms or queries?

the access application I am using is the 2007 version.
thanks in advance
penfold1992

 

[mahenkj2]

I am not an expert but some pointers:

1. Split the database, thus database run efficiently.
2. Compact and repair also reduces dB size.
3. To run queries faster, setting Index properly for appropriate fields improves speed considerably.
4. If possible use .accdr version, loads faster.
5. Sometimes error in codes like infinite loop may cause troubles.
6. Run Analyze Performance to detect need of improvement.

Please remember to make back up before making any changes.

best regards.

 

[penfold1992]

I actually think its the access program itself, I dont know why but the application has ground to a halt. It takes 5 minutes to open and the application often crashes when closing or opening a database -.-

 

[shadow9449]

I want to add that Access 2007 will be really slow on older computers. Another thing you may be doing wrong is opening it over a wireless network which is in general not a good idea for a number of reasons, but expect it to be VERY slow if you are.

SHADOW

 

[DavidAtWork]

Are other applications also slow to load or is it just Access, also do you have multiple versions of Access installed
David

 

[penfold1992]

no just the one version and I am running it on a laptop provided by the company over a wired link... its strange that it acts up and runs slower then others =S