Forum Discussion
Form Design Changes - Long Delay When Saving
Hello Everyone,
I’m new to this forum and appreciate any help others might be able to provide.
I recently developed an Access database with a form that includes buttons which when clicked run queries and displays the results. Nothing special, just basic queries. However, any time I save a change to the form design (add a button, change the text of a label, etc.) or change from form design to form view, it takes anywhere from 7-10 minutes. If I modify or create a new query, saving those updates only take a few seconds. It is just when trying to save a form that takes a very long time.
Some facts about the database:
- Using the latest version of MS Access provided with Office 365.
- Using a split database with the front-end on a local PC and the back-end on a network server.
- There are ten tables linked to ten .csv files on the network server.
- Total size of the front-end database is 1,444 kb
- Total size of the back-end database is 14,736 kb
- Perform Name AutoCorrect has been deselected.
- Track Name AutoCorrect is still selected.
I’ll be happy to provide any additional information if it will help.
Any thoughts on what may be causing the issue?
Thanks in advance.
Pete
4 Replies
- Do you still have a copy of the "bad" version? Could you make it available to MSFT for research? While I agree that Name AutoCorrect can cause a delay, I find it hard to believe that could be more than a few seconds, not a few minutes.
Hi,
First thing I would try is to get completely rid of Name Autocorrect. Not only by deactivating the Track option but:
- create a new accdb
- deactivate ALL Name Autocorrect options
- import all objects from the old file
- test if the delay still happens
Servus
Karl
*********
Access-Entwickler-Konferenz: https://www.donkarl.com/?AEK
Access DevCon: http://AccessDevCon.com
Access FAQ: https://www.donkarl.com- Well, was finally able to resolve the issue. In the Options menu for the Current Database I deselected all "Name AutoCorrect" boxes and selected the "Clear Cache on Close" option. Once I did that it worked perfectly. Only takes a second to save changes and navigate from form design to form view. So, if anyone else is having similar issues it might be worth a shot to make the same changes to see if it resolves the problem.
Thank you so much for your post - this worked immediately for me while experiencing the same problem - thank you - you saved me many minutes if not combined hours of frustration!
