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