Hi all,

In Access2003 I have a frontend of about 2MB (backend is about 1,5 MB and
has about 8 tables). The frontend consists of 4 forms, 6 reports, 2 modules,
and some queries. The biggest and main form in the frontend seems like a
normal form to me. It has a subform in it and in my eyes not too much code.

However, when I make a simple change to the form, for instance making a
field bigger or add a button with 3 lines of code, and I want to save the
form it takes 1 to 2 minutes to save. Although there are no signs of a
corrupt database I tried compact and repair. This action is done properly
but still it doesn't change the amount of time it takes to save the form.

Is this normal behavior? Does anyone has some pointers to further
investigate this?

I'm thinking about rebuilding the whole form but that will take me a lot of
time, escpecially for putting the code in the right places, naming the
fiels, and layouting the form. But if that would be a solution, does anyone
have tips to make this process easier? Maybe a simple copy-and-past action?

Thanks in advance for any advice,
Cheers.
John