Date Modified changes and causes problems

[Guest]

Hi,
I have a few users who launch some Access databases from another
application called TcE. When a user opens a database, even if it is
read-only, the date modified is updated. This is "badness" because TcE
thinks that the file has changed and it automatically creates a backup file
of the database.
So here's what I need to know...how can I create an Access database that
does NOT update the 'Date Modified' after a user opens it? The users are not
changing the database in any way...they are simply using the database to
query some information, which is outputted to Microsoft Excel. Any
suggestions?

Thank You!
Jessica Stout
(e-mail address removed)

 

[Douglas J. Steele]

Sorry, that's the way Access is. There's no way to change that behaviour.

What you could do, I suppose, is use a batch file to open the database, then
change the date back once it's shut down. I know that there are utilities
that allow you to change a timestamp, but I'm afraid I don't have the names
of any of them handy.