How to determine the last modified date of a database

[menstroy]

Hello,

I would like to pull in from the access database properities the modified date... Is this possible? I want to show it on a form kinda of a revision number/stamp.

thanks

 

[psemianonymous]

I don't know exactly what you mean by 'modified', because every time you open the database, you edit the file. Thus, pulling the file's 'last edited' date will bring up 'Today, 3 seconds ago', every time. Regardless of whether you edit records or create queries or whatnot.


So I'd recommend you store the version number in some sort of table, and pull the version number from the table displayed in the form. Or just put the version number in the form directly.

 

[menstroy]

What if the database is being opened as read only? This database shouldnt be updated but by 1 or 2 people out of 500 users