How do I get a file's date modified ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get the Access back end's last date modified and display it in the
front end db, so users can the date when they start the app.

Thanks
 
What I am looking for is a method for the front end db to find and display
the date/time modified of the back end db.

Douglas J. Steele said:
VBA has a built-in FileDateTime function.
Click to expand...
 
And the FileDateTime function will do that. All you have to do is pass it
the name of the back end database.

If you don't know the name of the back end database, you can parse it out of
the Connect property of any of the linked tables.

Remember, though, that as soon as a user touches the back end database, its
last modified date gets changed, even if they don't actually update it.

If what you're after is actually the last time a record was updated in the
back end, you'll have to add CreatedDtm and/or LastUpdatedDtm fields to each
record, and write queries against each table to determine the most recent
record date.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Rick said:
What I am looking for is a method for the front end db to find and display
the date/time modified of the back end db.
Click to expand...
 
Thanks Doug,

Your idea about adding a LastUpdatedDtm field to a table would be the best
method. There is a table in the back end that holds the configuration
settings in a single row. I'll add the LastUpdatedDtm field to that row, and
update it when a user exits the front end. On start up this will show the
user when the last date and time that the back end was modified (or at least
viewed).

Thanks!

-Rick
Harvest Data Systems
New Port Richey, FL
 
Back
Top