Form Design Changes - Long Delay When Saving

%3CLINGO-SUB%20id%3D%22lingo-sub-2908922%22%20slang%3D%22en-US%22%3EForm%20Design%20Changes%20-%20Long%20Delay%20When%20Saving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2908922%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20new%20to%20this%20forum%20and%20appreciate%20any%20help%20others%20might%20be%20able%20to%20provide.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20recently%20developed%20an%20Access%20database%20with%20a%20form%20that%20includes%20buttons%20which%20when%20clicked%20run%20queries%20and%20displays%20the%20results.%20Nothing%20special%2C%20just%20basic%20queries.%20However%2C%20any%20time%20I%20save%20a%20change%20to%20the%20form%20design%20(add%20a%20button%2C%20change%20the%20text%20of%20a%20label%2C%20etc.)%20or%20change%20from%20form%20design%20to%20form%20view%2C%20it%20takes%20anywhere%20from%207-10%20minutes.%20If%20I%20modify%20or%20create%20a%20new%20query%2C%20saving%20those%20updates%20only%20take%20a%20few%20seconds.%20It%20is%20just%20when%20trying%20to%20save%20a%20form%20that%20takes%20a%20very%20long%20time.%3CBR%20%2F%3E%3CBR%20%2F%3ESome%20facts%20about%20the%20database%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3COL%20class%3D%22%22%3E%3CLI%3EUsing%20the%20latest%20version%20of%20MS%20Access%20provided%20with%20Office%20365.%3C%2FLI%3E%3CLI%3EUsing%20a%20split%20database%20with%20the%20front-end%20on%20a%20local%20PC%20and%20the%20back-end%20on%20a%20network%20server.%3C%2FLI%3E%3CLI%3EThere%20are%20ten%20tables%20linked%20to%20ten%20.csv%20files%20on%20the%20network%20server.%3C%2FLI%3E%3CLI%3ETotal%20size%20of%20the%20front-end%20database%20is%201%2C444%20kb%3C%2FLI%3E%3CLI%3ETotal%20size%20of%20the%20back-end%20database%20is%2014%2C736%20kb%3C%2FLI%3E%3CLI%3EPerform%20Name%20AutoCorrect%20has%20been%20deselected.%3C%2FLI%3E%3CLI%3ETrack%20Name%20AutoCorrect%20is%20still%20selected.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%E2%80%99ll%20be%20happy%20to%20provide%20any%20additional%20information%20if%20it%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20what%20may%20be%20causing%20the%20issue%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance.%3CBR%20%2F%3EPete%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2908922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForm%20Design%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2920410%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Design%20Changes%20-%20Long%20Delay%20When%20Saving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20thing%20I%20would%20try%20is%20to%20get%20completely%20rid%20of%20Name%20Autocorrect.%20Not%20only%20by%20deactivating%20the%20Track%20option%20but%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3Ecreate%20a%20new%20accdb%3C%2FLI%3E%0A%3CLI%3Edeactivate%20ALL%20Name%20Autocorrect%20options%3C%2FLI%3E%0A%3CLI%3Eimport%20all%20objects%20from%20the%20old%20file%3C%2FLI%3E%0A%3CLI%3Etest%20if%20the%20delay%20still%20happens%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EServus%20%3CBR%20%2F%3EKarl%20%3CBR%20%2F%3E*********%20%3CBR%20%2F%3EAccess-Entwickler-Konferenz%3A%20%3CA%20class%3D%22moz-txt-link-freetext%22%20href%3D%22https%3A%2F%2Fwww.donkarl.com%2F%3FAEK%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.donkarl.com%2F%3FAEK%3C%2FA%3E%20%3CBR%20%2F%3EAccess%20DevCon%3A%20%3CA%20class%3D%22moz-txt-link-freetext%22%20href%3D%22http%3A%2F%2FAccessDevCon.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2FAccessDevCon.com%3C%2FA%3E%20%3CBR%20%2F%3EAccess%20FAQ%3A%20%3CA%20class%3D%22moz-txt-link-freetext%22%20href%3D%22https%3A%2F%2Fwww.donkarl.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.donkarl.com%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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:

  1. Using the latest version of MS Access provided with Office 365.
  2. Using a split database with the front-end on a local PC and the back-end on a network server.
  3. There are ten tables linked to ten .csv files on the network server.
  4. Total size of the front-end database is 1,444 kb
  5. Total size of the back-end database is 14,736 kb
  6. Perform Name AutoCorrect has been deselected.
  7. 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

2 Replies

Hi,

 

First thing I would try is to get completely rid of Name Autocorrect. Not only by deactivating the Track option but:

 

  1. create a new accdb
  2. deactivate ALL Name Autocorrect options
  3. import all objects from the old file
  4. 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.