Access 2000 Saving Changes to design of form

  • Thread starter Thread starter Alan White
  • Start date Start date
A

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?
 
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
 
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?
Click to expand...

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.
 
Back
Top