Form opening/saving very slowly

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top