Please stop Access 2013 from automatically changing the Modified Date on Access files if no changes are made to a file
I have Office Professional 2013.
I have it installed on an Asus Laptop running Windows 8.1.
Also OP 2010 on Windows 7.
I open 99% of my files through "File Explorer" as I have several thousand (files) sorted into numerous sub-folders.
Whenever I open an Access file to check some details and then close it WITHOUT MAKING CHANGES "File Explorer" shows that Access has automatically changed the "Date Modified" to the most recent date and time that I open and then close the file.
This is despite the fact that the last time I may have made a change whether in design or data entry to the file was 2 - 5 years earlier.
This is unbelievably annoying.
Please have the Microsoft programming department make a modification so that the "Modified Date" policy is the same for all Office Professional programs and will only be updated if changes to design or data entries have been made. Please apply this to Access 2010, 2013 and 2016. I like many people have several computers with different Office Pro versions.
I sometimes have several hundred to a thousand files of very similar names and use the Date Modified to sort or get information from them.
Why is it that if you open a MS Word 2013 file and close it without changes there is NO date change to "Date Modified" when you view the file in File Explorer?
If you open a MS Excel 2013 file and close it without changes there is NO date change to "Date Modified" when you view the file in File Explorer?
Sometime if you make a change in Excel or Word and then decide against it both programs first ask if you want to update changes and if you say no Word and Excel store the original dates and DO NOT CHANGE THE FILE DATE TO THE MOST CURRENT DATE OF OPENING.
Yet if you open MS Access 2013 and close it without changes there is ALWAYS a date change to "Date Modified" when you view the file in File Explorer?
If a solution currently exists to stop the date from changing when there have not been any changes then I would appreciate knowing how to stop it.
I have gone through the Microsoft Community and other sources and wasted several days to solve this problem but no-one seems to have an answer. In the process of searching I have found many other people frustrated with the date change problem .
Why is there no continuity in Microsofts multiple program designs with respect to this problem.
I have been buying Office Pro & access when it was a separate program for as long as they existed and have always had this problem. I never had this problem when I also used Paradox.
I'm late coming to this party but this is also very frustrating to me as well. One option I found (although tedious) was to right click on the file name, go to Properties, and on the Previous Versions tab, select the one with the date from before. Not a great answer but an answer.
This still needs to be corrected by MS!
I've experienced something right opposite. I have an VB.net app which uses .mdb file to store the data. File date and time for this file IS NEVER updated for some odd reason. I find also, that somewhere in roaming properties is a more current version of that data WITH RIGHT timestamp. This makes backup & other routines very difficult. Has anyone any idea how to disable this caching to write ALL the data back to where it REALLY belongs?
Jay M. commented
I share your concerns and frustrations. While I can't say enough about the data crunching capabilities, I am constantly bothered by the "date modified" issue. Always concerned that I will inadvertently update a stale copy of database and lose prior revisions.
The best solution I came up with is to place all my files in a "view only" folder for all Access files, and use it purely for that purpose. The data will of course become quickly stale for active files, but the setting up of the folder takes less than one minute.
If anyone has a better suggestion, please share!
I agree it is terrible that the "date modified" changes when nothing has been modified, I need dates to understand about when I last touched a file. Opening it and then quiting out without any changes has not modified the file.
Allen Belkin commented
I've recently been working in Access and find this really annoying. Many people have said that "it's just the way it works" but it's another example of Access' poor design. It makes it nearly impossible to figure out which file is most recent - the only way to do it is to sort the navigation bar by last modified and write down the dates and times and the most recent component in each section.
David Harding commented
I agree with this one. Surely Access should know if you've changed anything in the file (Excel and Word do. They remind you to save if you've changed anything.)
I have a lovely little Access VBA utility that will automatically find the latest version of a file.
But it doesn't work with Access file, because access thinks that the latest version is the one you last opened.
Mark Burns commented
You are complaining about something that is proverbially as old as the hills, and is a "symptom" of the normal operations of the Jet/ACE Database engines. In short, when a locking file is created upon opening a database file (and/or subsequently deleted) things ARE written to the database file, and the date updated is modified accordingly AND CORRECTLY for the OS/filesystem's rules of operations.
In short, if you really want this sort of capability, then move/copy all the database files to a folder with READ ONLY permissions (no Create/Edit/Delete permissions in the folder), and you can then open them with impunity and suffer no ill effects on the file's last updated datestamp. You WILL suffer the slings and arrows of Access complaining about the Read Only folder permissions, however.
This is a case of picking your poisons, I'm afraid.