My access fron-end is slow

[Marco]

Hi. I have an database here that is working as front-end. The back end is
also in access.

My front-end has a few, not many tables. Some local, some linked to the
back-end and some linked trought ODBC to an AS400 (db2) tables, and two
linked to text files.

I've got several queries, several forms and reports. Only a few macros and 3
modules.

I have auto-correct disable in options and also auto track.

So, my problem is that I'm starting to check that my front-end is a little
bit show.

What can I do to make it faster?

I already compact it.

Is there a tool to shrink it more?? Even if I have to pay of course.


Regsards,
Marco

 

[mscertified]

What particular operations are slow?
Look at all your queries and test them for speed.
Don't bind forms to an entire table, use filter to look at one row at a time.
Look to make linked tables local if they don't change often.
Compile to an MDE.

-Dorian

 

[Tony Toews [MVP]]

So, my problem is that I'm starting to check that my front-end is a little
bit show.

What can I do to make it faster?

I already compact it.

Is there a tool to shrink it more?? Even if I have to pay of course.

No. Even compacting the FE won't make much of a difference.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/