Link to home
Start Free TrialLog in
Avatar of Phil
PhilFlag for United States of America

asked on

Access 2013 ".accdb" file dates not updating consistently

Access 2013 ".accdb" files dates do not change in Windows File Explorer consistently when the database file is closed. In the old ".mdb" days the file date/time changed without fail, every time the file was opened and then closed.

This change in behavior for Access 2013 files has caused me to load an older version for updating inadvertently multiple times. Needless to say this is very irritating.

Any solutions?

Thanks!
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Usually pressing F5 solves this.
I don't know if F5 will resolve the issue but probably another idea would be to have a table that stores the current date time/date when you close your application (Deactivate event is pretty good for this kind of task) and when you open your Access had it read this value and displayed somewhere .e.g. Status Bar
I keep a change log in each FE to summarize changes and when they were made.  The menu always shows the details of the last row in the table  so that clarifies the issue.  It takes a little discipline to do this.  The other thing I do is to back up frequently and I do that by zipping the FE and including the change date in the file name.

 This change in behavior for Access 2013 files has caused me to load an older version for updating inadvertently multiple times. Needless to say this is very irritating.
Correction: This is your MS Windows behavior, MS Access is nowhere related to displaying files attributes.

Are your files located on a network ?
If so, some network strategies can cause this, not much you can do about it if you arn't sys-admin.
Side notes: When you are developping, I do not recommend working on an MS Access database directly from a network location.
First reason is (obviously) for performances issues.
Second reason is because your application is yet to be finished (thus, unstable), you run an increased risk of corruption and work loss.
Avatar of Phil

ASKER

I tried F5 both from within the application and also while the file is selected in Windows Explorer and that did not work.

I may have to establish a different set of rules to maintain my file modification history and file names but I shouldn't have to.

I am not running on a network as I purposfully do not network my machines because of virus threats. This is a stand alone Windows 10 system.
Avatar of Phil

ASKER

Incidentally, "MDB" files still behave as they always have. Open them, Close them, and date/time is changed to current. So, It's an "accdb" issue.
I've never run into this issue.  In fact I hate it that Access changes the file when I just open it without making any object modifications.

Are you opening the database in exclusive mode?  That might alter the Access behavior.
Avatar of Phil

ASKER

If I'm opening it in exclusive mode I'm not aware of it.  I like to have the date/time change so I can just sort by file date and open up the most current version. I guess one way I can do this is during my development phase I could convert it to an "mdb" and then change it back to "accdb" when I deliver it to my client.
Avatar of Phil

ASKER

I just closed my application, then opened it up again, did a compact and repair, and then closed the application again.

The file date/time in Windows Explorer shows May 24, 2018 6:53AM. However, if I hover my cursor over the name of the file it shows the time the file was closed the second time: May 24, 2018 3:31PM.  But, Windows Explorer is using the incorrect date for sorting. Sometimes the date may be a couple days off, even though I've opened and closed it multiple times. I save new version of these files multiple times each day because of frequent crashes.
Check to see what properties you are displaying in Windows Explorer.  There are a large number of them and perhaps, you are displaying the wrong date field.

Also, you should use better development practices.  You should never be relying on the date to determine which version is current.  What if you needed to look at a prior version?  That would change the date and now where are you.

Good practice for keeping track of development versions:

1. Close the development copy every hour or two when you are doing heavy development or at the beginning or end of the day.
2. Zip the file you just closed and give it a date and a sequence letter -180524b suffix.
3. Move the zip file to the OLD folder.
4. Compact the current version.

That gives you a solid place to revert to if you do something dumb and clobber your working copy.  Been there, done that, have the t-shirt that says "Shoot me now".
Avatar of Phil

ASKER

I just click the "Details" icon and it pick the info to display as I always have. I do not see any way to select another date field. With "MDB" files dates/times are changing as expected, it doesn't look like am exclusive Windows File Explorer issue.

How can I view all field display options in Windows File Explorer?  Thanks
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Phil

ASKER

By choosing the Modified date, my problem is solved. Thank you very much Gustav Brock!

Now I just need to know how to spread points on this site. I see a note that this is possible but no clear path to complete it. They should have a table displayed with all participants and drop downs to spread points.
As I said, Windows issue ....
Check to see what properties you are displaying in Windows Explorer.  There are a large number of them and perhaps, you are displaying the wrong date field.
Apparently words are worth nothing.