Form opening/saving very slowly

G

Guest

I have a particular form that rather suddenly has become very slow when
saving (over 20 seconds) or when switching from design to form view after a
change has been made. It opens fast enough when no change has been made, but
is slow saving whether anything has changed or not. It is fairly complex (38
bound controls, 24 unbound); however, I am unable to make it any less complex
without significantly complicating the user interface with multiple forms.

I already tried these, to no avail:
Compact/repair
Create a completely blank DB, then import all my forms
Compile VBA

What does Access do when saving the form? Does it validate row sources,
etc.? Are there any options I can set to alleviate this problem?
 
G

Guest

Followup: it is much faster, when making a VBA change only, to save from the
VBA screen, and then not save the form. It is slow saving the form, even if
the only change was a VBA change or nothing was changed.
 

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

Top