Access 2000 Saving Changes to design of form

[Alan White]

I have a large database with many forms.
When I modifiy the code behind a form and then close the
form I am asked the following question.

"Do you want to save tge changes to the design of the
form ..."?

When I answer Yes it then takes more than a minute to save
the changes. Why does it take so long? Is there anything I
can do to make it quicker?

 

[Allen Browne]

The speed will be *way* slower than Access 97 was, as the newer versions
rewrite all the objects instead of just the one you requested.

There may be some things you can do to help though, e.g. turn off Name
AutoCorrect under Tools | Options | General, and making sure no other user
is accessing forms/reports. (For multi-user databases, the database should
be split so each user should have their own copy of the front end.)
Correctly dereferencing your objects might help also.

Other general suggestions for performance in Access:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Guest]

Thank you Allen,

This is what I suspected was the problem.
Thank you for your suggestion about AutoCorrect.
Your link to
http://www.granite.ab.ca/access/performancefaq.htm
is also very helpful.

Would using Access.mdb's as Library files to store code
and forms and then use references - be helpful?

Alan

 

[Allen Browne]

Alan replied in message news:[email protected]...

Would using Access.mdb's as Library files to store code
and forms and then use references - be helpful?

We have found it easier just to import the standard code into each app you
develop than to use a library of code, mostly to avoid the problems with
missing references. The fewer the references, the lower is the risk of
something going wrong.

If you store all the code that would be in the library in a single module,
it is dead easy to update an app by deleting the module and importing your
more up-to-date copy.