Exit Access without changine MDB file date

[Guest]

When I look at an existing MDB file in windows explorer it has a date of last
change or creation. If I open the MDB in Access and just exit, that date
changes even though I made no changes and did no save. I want and need the
date to not change, how do I do that?

 

[Joseph Meehan]

When I look at an existing MDB file in windows explorer it has a date
of last change or creation. If I open the MDB in Access and just
exit, that date changes even though I made no changes and did no
save. I want and need the date to not change, how do I do that?

I am not sure you can do that, but you can program it to keep that last
changed date in a separate table. You could even keep a list of dates
changed, users who did the changes and if you like the actual changes they
did.

How well acquainted are you with VBA?

 

[John Vinson]

When I look at an existing MDB file in windows explorer it has a date of last
change or creation. If I open the MDB in Access and just exit, that date
changes even though I made no changes and did no save. I want and need the
date to not change, how do I do that?

AFAIK the only way to do so is to use Windows properties to make the
database read-only (which will, of course, prohibit any changes to
either the data or the structure of the database). These Windows dates
are not particularly useful, for this very reason. If you want to keep
track of dates, you'll need to maintain them yourself, either in a
table or in custom database properties.

John W. Vinson[MVP]