misbehaving form

[Kurt Neumann]

I have a very strange problem, using Access 2000 and wind XP.
I have imported a form from database2 to database1. All of the form's
tables, queries, and reports have been imported also and now reside in
database2. The form loads and functions perfectly well. If, however, I
edit and change the form in any way and save it, it then takes an extremely
long time to load, as long as 10-15 seconds!
I have repeated and reliably created the problem. Even if I merely comment
out an unnecessary line, the form no longer loads well. Even if I merly add
a command button to close the form, etc. If I then remove the changes and
save the form with the original controls and code, it still loads slowly.
If I reimport the "virgin" form from database2 again, it loads and functions
perfectly well.

I appreciate any help.
Thanks
Kurt Neumann

 

[Sylvain Lafontaine]

Mabye a corruption problem. You should check the references (particularly
their order) and decompile/recompile all your stuff. If necessary, create a
blank new database and import everything into it.

Make sure that the recompilation doesn't show any problem. Also, make a
test with error trapping control deactivated: set the Error Trapping option
to Break on All Errors (VBA --> Options --> General tab).

 

[MacDermott]

Would you perchance be using a copy of Access 2000 without the service
packs?
I recall such behavior from those bad times. Access 2000 should always be
used with the service packs.

 

[Albert D.Kallal]

This is often reported in this newsgroup a result of track-name autocorrect.
We see this post a lot here.

I would simply turn off the feature as it is simply a souce of pain...

There is list of got-ya's to check for peformance here, and track name is
mentioned:

http://www.granite.ab.ca/access/performancefaq.htm