In today’s topic we will discuss about how to troubleshoot the Access Database Saving Changes Issue whether it is encountered in Access 2003/2007/2010/2013/2016. Mostly it is seen that user faces this Access Database not saving changes issue in two situations either while saving the design changes or while making any updation to the form or report.
“I am not able to save any changes to an Access Form. It comes up with “”Do you want to save changes”” and I say “Yes”, it doesn’t do anything. I have to hit No to get out of this. I have tried to repair and compact database but with no use. I also tried to export the form to a new database but it comes up with naming conflict error.”
If you too facing similar issue in your Access Database then don’t go anywhere just goes through this post. As, it contain complete solution for all your Access Database Not Updating issue. So, just go through it….!
Issue 1: Microsoft Access Can’t Save Design Changes
MS Access application won’t allow you to save an offline copy of a design unlike desktop databases. If you get disconnected to server connection at the time of designing the access application, you won’t notify until try to save your work. At which point you will get an error.
In order to save changes click to the OK option and leave Access open while trying to attempt to restore the connection. Once your connection is restored save your changes.
You may also like:
Note: if in case won’t be able to restore your connection without closing Access, then you will lose all the design changes that you have done since the last time you saved.
You Must Use An Exclusive Lock To Save Design Changes To Database Objects In Access 2003
This issue commonly encountered at the time of customizing a toolbar or when you try to open a Microsoft Office Access 2003-specific object like form, report, macro, and module. This shows following error messages to your computer screen.
You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
If you are trying to save design changes which you have made to an Access 2003 database form, module, macro, report. Then it will show the following error message:
Microsoft Office Access can’t save design changes or save to a new database object because another user has the file open. To save your design changes or to save to a new object, you must have exclusive access to the file.
While trying to save new data access page, you will get the following error message:
A link to this data access page could not be created because the database cannot be exclusively locked.
To create the link later, open the page by selecting ‘Edit web page that already exists’, and then save.
You can’t create or modify data access pages in Microsoft Office Access 2007.
The main causes behind the occurrence of this Access Won’t Save Design Changes issue are:
- Open a form, report, macro, module or command bar in design view.
- Try saving the design changes to the object type.
- when trying to save design changes to new page link and other user accessing the same database that you are using.
Resolution For Access Can’t Save Design Changes
In order to save design changes to object type in your respective Access Database must have an exclusive lock on the database. If multiple users are designing on the same database then you must implement source code control by using the Microsoft Visual SourceSafe Add-In for Access 2003.
Apart from that you can distribute local working copies of database to each user.
Issue 2: Access Form Or Report Does Not Display All Of The Data
This problem of Access form or report does not display all data occurs at the time of creation of Access form or report. And also when you apply a filter before saving it for first time after then save it while the filter is still in effect, the filter can’t be turned off. Form or report will always show filtered view of the underlying table or query.
It’s a new feature designed to easily create permanently filtered forms and reports. Microsoft office Access 2007 accomplish this by incorporating a filter into the object’s design, if that filter is in effect when the object is first, if that filter is in effect when object is firstly saved.
You may also like:
Resolution To Fix Access Form Or Report Does Not Display Issue:
If you don’t need a filter that applied to a newly-created form or report to get permanent then you need to remove the filter before saving the object for the first time.
But if in case you have created a form or report and saving it for the first time mainly when it is in a filtered state. Later on you have decided that you don’t want the filter to be permanent, you can edit the object’s Record Source property just by following the below mentioned steps.
Remove A Permanent Filter From A Form Or Report
- From the navigation pane, right click the form or report.
- After then click on the shortcut menu click to the Design View. This will open the object in Design View.
- If property sheet is not appearing then press F4 to display it.
- Tap to the object’s Record Source property box, after then click to the . This will open the Query Designer, with the Object’s Recordset Query displayed.
- For the filtered fields and criteria check in the query design grid. In following figure, there is one filtered field, Company Name, and a single criterion, Contoso, Ltd.
- Select column that contain a filtered field just by tapping the gray bar which is present just above the Field row in the query design grid.
- After then hit the DELETE option to remove off the filtered field and its criterion.
- For each filtered field that you want to remove from the object’s design you need to repeat the steps 5 and 6.
- Close the query designer when you are prompted to save the changes made to the SQL statement and update the property.
- At last click to the Yes option.
Now you have removed permanent filter from your form or report.
If you remove permanent filter from a form or report following the above steps then it doesn’t preclude you from using same access filter on this object again in the future. It only removes it from object’s design so that you can view all the records that contained in the table or query by default.
Try The Recommended Option:
Sometime the issue of not saving also arises when your access database file already get corrupted. So in that case you need to use the reliable third party repair tool like Access Database Recovery And Recovery Tool.
It’s a perfect software to fix this access form not showing data issue as it helps you to repair and recover any damaged, corrupted or inaccessible database. With the help of this tool you can easily fix any kind of MS Access error. This tool is not only fixes errors but also fixes the .mdb or .acccdb files and recovers the data from your corrupted MS Access database. You can also restore the indexes, tables, queries and relation by using this tool.