Hi All,

I am trying to find a way to create an audit system of auto entering of dates, however user's have a nasty habit of playing with the system and bios clock and therefore invalidating the use of date and now in the vba.

Can anyone suggest a way to get the correct time and date to flag this within the system and thereby ensure that the correct date is being used as close to all times as poss.

Cheers

It's kind of hacky, but if you could use XMLHTTP within VBA in Access, you could hit some web page on some server that you control that would return the current date/time.

But so long as you are restricted to getting time/date from the local computer, I don't see how you could possibly know any different from what the system clock tells you.

I'm curious. If you were to create a file and place it on a network drive instead of the user's C: drive, would the file creation date and time be that of the user's computer or the server in which the file resides? If the latter, perhaps instead of a time stamp, you could create/edit & save a small ASCII text file and then note the time of creation/last save. IF the time is that of the network server and not the local computer, that is something users cannot mess with.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division