Exit Access without changine MDB file date

M

Mr ED

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?
 
J

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?
Click to expand...

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]
 
Top