Access Database Modified Date

  • Thread starter Thread starter Laura S
  • Start date Start date
L

Laura S

Any time I run a query, the modified date is changed to the date run. Why,
and how can I get this to stop happening? It is a real nuisance, as I can't
tell what I have changed recently.
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
On Mon, 17 Mar 2008 09:53:01 -0700, Laura S <Laura
Any time I run a query, the modified date is changed to the date run. Why,
and how can I get this to stop happening? It is a real nuisance, as I can't
tell what I have changed recently.
Click to expand...

The "Modified Date" that you see in the Windows properties of the .mdb file
indeed does as you describe. AFAIK there is no way to control it. Just opening
the database and looking at data does in fact modify the internal contents of
the .mdb file, whether you make any design changes or not. Microsoft isn't
saying, but I speculate that it's storing query statistics to optimize future
query operations.

If you need to keep track of your own design changes and when they were made,
your only option is to create a table and keep track of them yourself.
 
Back
Top