Microsoft Access 2003 Database too slow

[ishfady]

Hi

I have Microsoft Access 2003 Database running on Windows XP professional and shared with other four users.

Whole database is running from this pc.

Database is working fine. But for some reason it is slow.

Is there any way I can improve it perfomance ie speed.

Please could you help me with my problem


Many thank

 

[Trendsetter]

I would be looking at the network configuration and the network cards being used - ensure that you are running the network at the maximum speed possible.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[RoyVidar]

Some good reading here Microsoft Access Performance FAQ, Making Access Faster - 168 Tips to Speed Up Your Apps!.

Of course mentioned in the links...
* turn off Name Autocorrect
* set subdatasheet name property of tables to [ignore][none][/ignore]


Roy-Vidar