Form saving too slow

  • Thread starter Thread starter Patrick386
  • Start date Start date
P

Patrick386

Hello!

What can make the saving of the form become too slow?

I wait about 1 minute to save a form.

Is it because it has many controls, subForms (subForm's SourceObject is set
on runtime), code module and images..

Is there a way, except to remove the objects mentioned above, to make the
saving time go faster?

Thanks in advance for any suggestion!
 
If this were mine, I'd probably make a backup copy and then start removing
objects and re-saving to see which object/objects contributed most to
speeding up the save.

But in the long run, are you talking about saving the changes in the design
of the form, or are you talking about saving a "new record", using the form?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for the hint!

from what I saw, it doesn't take long when I need to save design changes.
but it takes too much time to save the code changes.

I will apply the hint: backup, remove the module, and paste part by part of
the code, and I will see

Thanks again

Best regards
 
Perhaps only a terminology issue, but I figure design changes to a form
include code changes and physical rearrangement.

Also, Access has been know to become corrupted in subtle ways. Consider
re-creating the form if your other approaches don't work.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top