Form Saves too Slowly

[Sammie]

I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie

 

[Allen Browne]

Work through the items in Tony Toews' list in the:
Access performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Dirk Goldgar]

I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie

In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.

 

[Sammie]

In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.

That was exactly the problem! Makes a HUGE difference. Thanks.