Optimize Performance of Access DB

M

M P

Hi!

Need your help, I have 500MB of Access 2000 DB that is accessed by multiple
users. How can I speed up its performance? It seems very slow when opening
one form to another.

Mark
 
J

JohnFol

I know this will sound flippant, but type in "optimize performance" in the
answer wizard and you will have chapters of information. . .
 
A

Arvin Meyer

1. Make sure your forms are running with optimized queries instead of entire
tables.
2. Make sure that there is good indexing on the underlying tables.
3. In table design view, set the subdatasheet links from [Auto] to [None]
4. Remove graphics from forms. Use optimized queries for all combo boxes
and list boxes.
5. Compact often.
6. Make sure your database is split, with individual front-ends running on
workstations.
7. Move static data (like country tables) to the front-end.
8. Go to the Knowledge Base, choose Access and your version and type in
"Optimize"

http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tony Toews

M P said:
Need your help, I have 500MB of Access 2000 DB that is accessed by multiple
users. How can I speed up its performance? It seems very slow when opening
one form to another.
Click to expand...

The three most common performance problems in Access 2000 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

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
 
G

G Lam

Hi, what are sub datasheet and Track name? Where can I find them?
Thank you.
Gary

Tony Toews said:
M P said:
Need your help, I have 500MB of Access 2000 DB that is accessed by multiple
users. How can I speed up its performance? It seems very slow when opening
one form to another.
Click to expand...

The three most common performance problems in Access 2000 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

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 DB not fuctional with multiple users 2
Word 2016 opening sooo slow 0
Subform Performance 15
WORD VBA Search and switch to advanced ... 1
Open a form while hiding Access DB interface. 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access networking slowness 3
Access across the WAN 37

Top