Tables opening slowly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In recent times my access db is opening tables very slowly. The tables are
not very big, and it's doing it with every table regardless if they have 3000
or 3 records. This problem is very new, and I suspect that the new Internet
Explorer 7 has something to do with it. I open the database across a network,
however, the same problem occurs opening the db on the host machine. I've put
the database in "My Trusted Sites." but that doesn't seem to do anything. The
IE7 installation is the only thing that I can think of that has been a major
new event that has occured to the system.

Any ideas?

Thanks!

Jesse
 
cutthroatjess said:
In recent times my access db is opening tables very slowly. The tables are
not very big, and it's doing it with every table regardless if they have 3000
or 3 records.
Click to expand...

Could there now be two different people in the database? If so the
second and subsequent person in will have poor performance.
Microsoft Access Performance - Speed up your Access 2000 Forms
http://www.granite.ab.ca/access/performanceforms.htm

If not then it could be something else on that above web page.

It is possible something in IE7 could've caused the performance hit
but I'm running IE7 myself and haven't noticed anything.

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
 
No, only one person at a time is using the db. The IE7 idea I knew would
certainly be a stretch. I don't have the same problem opening forms or
queries which is weird. It's just the tables.

Thanks!
 
MDB is _CRAP_

just use Access Data Projects; you don't have random AWFUL
PERFORMANCE.

-Aaron
 
cutthroatjess said:
No, only one person at a time is using the db. The IE7 idea I knew would
certainly be a stretch. I don't have the same problem opening forms or
queries which is weird. It's just the tables.
Click to expand...

Your users should never been seeing tables and seldom queries.
Occasionally I will give users read only access to queries to show any
data problems but that's it.

Your problem is likely the subdatasheets for which the Name property
set to [Auto] should be [None]

For more information on this problem 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
 
Back
Top