Very slow forms

[Rod]

I have taken over looking after a database for a charity.

It works fine on the machine it was set up on, but when I move it to another
machine it slows right down. I.e it can take minutes to load a form. (the
time is spent before any of the open or load events fire)
Even in design mode saving a form can take minutes (but seconds on the
original machine).
The form is complicated but the size of the database is small, 100s of
records only, but with many tables.

Anyone seen this sort of thing before or got any clues as to what to look
for.

thanks

Rod

 

[Scott McDaniel]

I have taken over looking after a database for a charity.

It works fine on the machine it was set up on, but when I move it to another
machine it slows right down. I.e it can take minutes to load a form. (the
time is spent before any of the open or load events fire)
Even in design mode saving a form can take minutes (but seconds on the
original machine).
The form is complicated but the size of the database is small, 100s of
records only, but with many tables.

Are the tables linked? Or is this a fully stand-alone database (i.e. all local tables, no linked tables). Linked tables
can cause a definite slowdown over a network.

Make sure that you have no missing references on the problem machine ... open the database, open the VB editor, and see
if any are marked MISSING. Generally this causes other problems (i.e. error messaes when the database is opened) but
it's worth a try.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Rod]

Are the tables linked? Or is this a fully stand-alone database (i.e. all
local tables, no linked tables). Linked tables
can cause a definite slowdown over a network.

Make sure that you have no missing references on the problem machine ...
open the database, open the VB editor, and see
if any are marked MISSING. Generally this causes other problems (i.e.
error messaes when the database is opened) but
it's worth a try.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

There are linked tables, but would you expect this to slow it down when
saving in design mode.

The mystery is why it can work OK on another (slower machine).

 

[Fred Boer]

Dear Rod:

Check to ensure that Name AutoCorrect is turned off - that may fix it.
You may also find the following useful:

http://www.granite.ab.ca/access/performancefaq.htm

and particularly...

http://www.granite.ab.ca/access/performanceldblocking.htm

That one fixed it for me when I had this problem.

HTH
Fred Boer

 

[Rod]

You're the man

ta

Dear Rod:

Check to ensure that Name AutoCorrect is turned off - that may fix it.
You may also find the following useful:

http://www.granite.ab.ca/access/performancefaq.htm

and particularly...

http://www.granite.ab.ca/access/performanceldblocking.htm

That one fixed it for me when I had this problem.

HTH
Fred Boer