Why is database so slow when more than one user is on?

[marle35]

When 2 or 3 people or on, Access is at least twice as slow. Is this normal? And if it's not, how do I find out why it's so slow?

FYI, in advanced options, the following options are set:

Default open mode: shared
Default record-locking: no locks
Open databases using record-level locking: TRUE
Enable DDE refresh: TRUE
OLE/DDE Timeout (sec): 30
Refresh Interval (sec): 60
Number of update retries: 2
ODBC refresh interval (sec): 1500
Update retry interval (msec): 250

 

[Ed2020]

A few things to try:

1. If your database is split ensure you are maintaining a persistant connection to the backend.
2. Turn off Name Autocorrect.
3.

http://support.microsoft.com/kb/275085/en-us?spid=2509&sid=49

Ed Metcalfe.

Please do not feed the trolls.....

 

[missinglinq]

For # 2 above, make sure you go to

Tools - Options - General - Name AutoCorrect

not to

Tools - AutoCorrect Options

as even the brightest people here have done from time to time!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[JerryKlmns]

Take a look here,

http://www.fmsinc.com/tpapers/faster/

Ed's suggestions are included