Slow

  • Thread starter Thread starter James
  • Start date Start date
J

James

My database is slow. I have a backend on a new server
running Windows Server 2003 consisting of a few tables. I
then have a front end mde file with about 20 forms,
stored
in the users home directory. there are about 10 users.

The problem is that it takes ages to do anything, to load
a form or to find someone (there are about 80,000
records). This even happens when I copy both parts to a
local machine which is why I don't think its to do with
the network.

Any advice would be much appreciated.

James.
 
Ok it could be that your network is running slow... or you
could try compacting and repairing your database this may
speed things up...

HTH

James
 
Hi James,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

You might experience slowness due to having the Name AutoCorrect features
enabled or I have seen slowness when the Subdatasheet Name property is set
to Auto instead of None for each table in the database. For more
information, please see the articles below.

261000 ACC2000: Slower Performance on Linked Tables
http://support.microsoft.com/?id=261000

200600 ACC2000: Slow Performance Opening Object with Name AutoCorrect
Enabled
http://support.microsoft.com/?id=200600

290181 Slow Performance When User Opens an Object with Name AutoCorrect
Enabled
http://support.microsoft.com/?id=290181

288631 Defragment and Compact Database to Improve Performance
http://support.microsoft.com/?id=288631

286222 How to Optimize Microsoft Access When Using ODBC Data Sources
http://support.microsoft.com/?id=286222

275085 ACC2002: Linked Tables with Subdatasheets Are Opened More Slowly Than
http://support.microsoft.com/?id=275085

Files on Network Shares Open Slowly or Read-Only or You Receive an Error
Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;814112

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.
 
Back
Top