Database S-L-O-W ... Help!!

[Tracey]

In design mode, my database is "extremely slow". I can hardly do any
designing. I've checked with my corporate help desk (who does not support
Access), and they've told me the problem it is not the size of my pc or the
network. I have my database on a shared network, but even when I file the
database on my harddrive and design from there, it is still extremely slow.
In this database, I have a lot of forms with subforms, reports with
subreports, buttons with macros etc. They are telling me I have maxed out
the capability of Access. Could that be possible? I don't think my database
is that huge, but could be wrong. What information can I give any of you
that you can help me to determine if this is the truth? I routinely
repair/compact my databases.

Thanks,
Tracey

 

[Aaron G]

Tracey,

Not sure if this will help, but it worked for this guy...

http://www.tek-tips.com/viewthread.cfm?qid=1087079&page=1

Here's the quote from the thread: "in the d/b, under tools, general tab,
there are switches on the right. Perform name auto correct is by default
checked. Uncheck it. It may increase performanace. It does for me most of
the time."

Aaron G
Philadelphia, PA

 

[Steve Schapel]

Tracey,

It is very unlikely that you have "maxed out the capability of Access".

Aaron's suggestion is a good one. In addition, something that sometimes
helps is to make a new .mdb file, go to the Fole|Get External Data menu,
and import all database objects from the existing application. After
this, you will need to re-setup Startup options, and References.
Assuming you have VBA code in the application, have you compiled the code?

 

[Paul]

Tracey I had exactly the same problem, I tried the suggestion about auto
correct and hey presto perfect instant response, well it solved my problem
anyway good luck!!
Paul

 

[Tony Toews]

In design mode, my database is "extremely slow". I can hardly do any
designing. I've checked with my corporate help desk (who does not support
Access), and they've told me the problem it is not the size of my pc or the
network. I have my database on a shared network, but even when I file the
database on my harddrive and design from there, it is still extremely slow.
In this database, I have a lot of forms with subforms, reports with
subreports, buttons with macros etc. They are telling me I have maxed out
the capability of Access. Could that be possible? I don't think my database
is that huge, but could be wrong. What information can I give any of you
that you can help me to determine if this is the truth? I routinely
repair/compact my databases.

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