Form saving too slow

[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!

 

[Jeff Boyce]

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

 

[Patrick386]

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

 

[Jeff Boyce]

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