Access 2000 on Network Slow

[Guest]

150 meg database on server & interface program resides on each user's computer. When one user activates program, no problem. The problem arises when the second user activates program & this user will take up to 15 seconds before it will display info required were the 1st user is able to navigate and retrieve info without delay. We've done everything from compacting dbs, defraging, & etc. Is there a switch we are overlooking in Access 2000? Your help will be greatly appreciated. Thanks!

 

[Cheryl Fischer]

Access MVP Tony Toews has some tips regarding performance at his site:

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

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

150 meg database on server & interface program resides on each user's

computer. When one user activates program, no problem. The problem arises
when the second user activates program & this user will take up to 15
seconds before it will display info required were the 1st user is able to
navigate and retrieve info without delay. We've done everything from
compacting dbs, defraging, & etc. Is there a switch we are overlooking in
Access 2000? Your help will be greatly appreciated. Thanks!

 

[Tony Toews]

150 meg database on server & interface program resides on each user's computer. When one user activates program, no problem. The problem arises when the second user activates program & this user will take up to 15 seconds before it will display info required were the 1st user is able to navigate and retrieve info without delay.

This sounds very much like the "LDB locking which a persistent
recordset connection fixes" problem at the Performance FAQ page which
Cheryl mentioned.

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