Very slow forms

R

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
 
S

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

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
 
R

Rod

Scott McDaniel said:
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
Click to expand...


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).
 

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

Youtube is a problem 6
Process being throttled every 5 minutes, why? 0
Access 2010 won't run vba code on form load 1
Slow loading sub-forms 2
Access Access Report Works on One Machine but not Another 3
PC very slow after un-installing software 4
Is my query at fault for a slow form? 7
Testing performance on a form 5

Top