MS Access database is slow

[Alhousani]

Hi everybody,
I have an access database which is around 40 MB after compacting it and I feel that it is slow especially when I open cross table form. Is there any way to speedup the databse.
Note: my databse is on the share drive in my work.

 

[Robert88]

Hi Alhousani,

If you are running this from a network share at work is the database split?

If not then by splitting it and leaving the back-end on the server and bringing the front end to your local client, means your local client does a lot of the microsoft access grunting instead of hogging bandwidth over the network to do the same job, less complaints about the network running slow.

In addition with your front end, I think Access 2003 give you an option to compile your mdb to an mde, also speeding up usage at your front end on your local machine, making it slightly faster again.

Hope this helps, otherwise ask more question.....

Robert88