I have a split database running under MS Windows 2000
5.00.2195 on a network server. It is very, very slow and
there are only 2 concurrent users. Any suggestions?
If the problem is the network, how can I get a benchmark
to show to management?
Thanks
Amy Vargo - 29 Jul 2004 20:57 GMT
Hi,
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
Disable all Name AutoCorrect features in the databases and for all tables,
set the Subdatasheet Name property to None if it is set to Auto. Also,
make sure you have the latest updates for Jet and Office applied. Please
review the following articles for more information.
824173 PRB: Microsoft Access Stops Responding When You Edit a Record That Is
http://support.microsoft.com/?id=824173
275085 ACC2002: Linked Tables with Subdatasheets Are Opened More Slowly Than
http://support.microsoft.com/?id=275085
200600 ACC2000: Slow Performance Opening Object with Name AutoCorrect
Enabled
http://support.microsoft.com/?id=200600
To check the Subdatasheet Name property:
1. Open your table in Design view.
2. On the View menu, click Properties.
3. Set the Subdatasheet Name property to None.
4. Save and then close the table.
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Amy Vargo
Microsoft Access Engineer
This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.
Tony Toews - 29 Jul 2004 23:38 GMT
>I have a split database running under MS Windows 2000
>5.00.2195 on a network server. It is very, very slow and
>there are only 2 concurrent users. Any suggestions?
>
>If the problem is the network, how can I get a benchmark
>to show to management?
Very unlikely to be network.
The three most common performance problems in Access 2000 or newer
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
If the problem is for everyone when starting up the MDB then it likely
needs a decompile.
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
cae - 30 Jul 2004 20:55 GMT
Thanks for the suggestions, I have begun implementing the
ones that apply to my situation.