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.
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.
