accdb date/time not updating consistently in Windows 10 file manager

Microsoft Access 2013 Professional Plus accdb file date/time not consistent when application closes. In the old "mdb" days it was easy to tell the most current version by sorting by date/time. Is there a way to force a date/time update?
pabrannPresidentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Use Compact and Repair on Close.
0
PatHartmanCommented:
This isn't related to Windows.  It is related to Access.  Every time you open an Access database, Access modifies something so even if you don't change anything, Access does and that causes the file attributes to change.  This is NOT a reliable way to determine which version of the app is newest.  You have to manage that yourself.  When I make backups, I add the date to the filename.

MyApp_20180227.accdb

Inside the app, I run a query that looks at the MySysObjects table and puts the last update date on the main menu. This method isn't perfect since MS doesn't always update the DateUpdate when I think it should but it is better than nothing.  You can just copy and paste this into your app and run it.

SELECT MSysObjects.DateUpdate, MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE MSysObjects.Type In (5,32768,-32764,-32766,-32757)
ORDER BY MSysObjects.DateUpdate DESC , MSysObjects.Name;

Here's a table of object types.  You might have objects that are not in this list.  If you do, please let me know what they are so I can update my list.  this list doesn't include any AWA objects because I never developed any of those.  It also doesn't include anything specific to  .adp's because I never developed any of those.  Not all the objects are included in the query because they get updated pretty much every time the app gets opened so there is no way to track their change date.

Type	TypeDesc
-32768	Form
-32766	Macro
-32764	Reports
-32761	Module
-32758	Users
-32757	Database Document
-32756	Data Access Pages
1	Table - Local Access Tables
2	Access Object - Database
3	Access Object - Containers
4	Table - Linked ODBC Tables
5	Queries
6	Table - Linked Access Tables
8	Relationships
9	Constraints

Open in new window

1
PatHartmanCommented:
If you elect to import the table, you can modify the qLastChangeDT to join to it.

SELECT MSysObjects.DateUpdate, MSysObjects.Name, MSysObjects.Type, IIf(IsNull([TypeDesc]),"Unknown",[TypeDesc]) AS [Desc]
FROM MSysObjects LEFT JOIN tblObjectTypeCodes ON MSysObjects.Type = tblObjectTypeCodes.Type
WHERE MSysObjects.Type In (5,32768,-32764,-32766,-32757)
ORDER BY MSysObjects.DateUpdate DESC , MSysObjects.Name;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

pabrannPresidentAuthor Commented:
Thanks Pat,  I wish it could also change the Windows date in the file manager but this helps. I guess the only way to achieve that would be to downgrade the database from an "accdb" to "mdb".
0
PatHartmanCommented:
Are you saying that the file date isn't getting changed?  I don't think that is an option.  It changes for me every time I open the app.  Perhaps, the user does not have update permissions and so Access can't actually update whatever it normally updates.
0
pabrannPresidentAuthor Commented:
Yes, the file date does not change consistently with the "accdb" files on my Windows 10 system.  Sometimes it will if I do a decompile. In the old days of "mdb", the file date/time changed every time I saved. After upgrading my applications to "accdb", the problem started.

With the instability of more recent versions of Office, Access crashes often during development. I save the current version multiple times every day, copy the file with an incremented number and then open the new file. I always sort the file manager by date to easily identify the most recent version, but I can't tell with the "accdb" files because the date/time does not change most of the time.
0
PatHartmanCommented:
The date on the BE might not change if you didn't update anything.  I don't remember whether it updates for viewing or not.  For me, the FE updates whenever I open it regardless of whether or not I make any design changes to anything which is almost as annoying as randomly updating.  It would be nice if the update date actually reflected an actual design change but it doesn't..
0
pabrannPresidentAuthor Commented:
On my system it doesn't even update on a compact/repair or any changed to the front-end. To test it, I just added a new front-end table, did a de-compile and then a compact/repair and the file manager still shows March 3, 2018 at 8:16am. I actually did it 3 times and no change.

Interesting, maybe it is a Windows issue.
0
ste5anSenior DeveloperCommented:
Compact and repair on close creates a new file, thus the file gets a new timestamp. So when the process is fast enough, then you won't see a difference in your time stamp, cause it hides the seconds.
0
pabrannPresidentAuthor Commented:
I have Compact on close checked in my Database settings and it does not change the file date when closed. I've even closed the file manager and opened another instance and still no change. My front-end file still shows a Saturday date after many changes and decompiles, closes etc.
0
PatHartmanCommented:
What version of Access are you using?  Also look in "about" and tell us the actual build number just in case it matters.
0
pabrannPresidentAuthor Commented:
I attached an image of my About info... Thanks
Access_About_Info.JPG
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 10

From novice to tech pro — start learning today.