Common Timestamps for Access 97 - TechRepublic
General discussion
November 16, 2001 at 02:58 AM
jrussell

Common Timestamps for Access 97

by jrussell . Updated 24 years, 7 months ago

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?

This discussion is locked

All Comments