Discussion Locked
Common Timestamps for Access 97
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am maintaining a multi-user Access 97 database that relys on timestamped records for some of it's processing. The timestamped records are generated by a line of code like this (where rs is a recordset)
rs!TimeStamp = Now()
The problem is that the Now() function returns the current time on the workstation, and the workstation clocks are not syncronized (syncronizing the workstation clocks via a time server is not a feasible option at this time). What I would like to do is obtain the time from a Windows NT4.0 Server with something like ...
rs!TimeStamp = GetTimeFromServer(ServerName)
Problem is, I don't know the API calls necessary to write the GetTimeFromServer function.
Can anybody help?