Access data on server locking

[Sandi]

I have a client that had 2 users running Access 97 with
the data stored on a Windows NT machine (Access 97). They
upgraded to a Windows 2000 server and the processing with
multiple users ground to a halt. We upgraded to Access
2000 hoping that would help, but hasn't made any
difference. Can anyone help?

 

[Tony Toews]

I have a client that had 2 users running Access 97 with
the data stored on a Windows NT machine (Access 97). They
upgraded to a Windows 2000 server and the processing with
multiple users ground to a halt.

The three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Van T. Dinh]

Try Tony Toews' article:

http://www.granite.ab.ca/access/a2kslow.htm