Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / July 2004

Tip: Looking for answers? Try searching our database.

Performance Issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cae - 29 Jul 2004 16:57 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?

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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.