ServerTime

[chris]

I am using front and backend MS Access 2000.
when users key in data on a form ,TIME always show the
local client time.
how am i able to use the backend/server time instead of
the client one?
Thanks for the answer

 

[Joe Fallon]

Access always uses the workstation clock.
The best you can do is synch the workstation to the server.

How to Synchronize Time on a Workstation to a Server using Access VBA Code:

Paste this code into a module and change the name of the server to one of
yours.
Test using Ctrl-G to open the immediate window and type TimeSynch and press
Enter.

This code hides and then closes the DOS window after execution is complete.

Sub TimeSynch()
Shell Environ$("COMSPEC") & " /c Net Time \\ServerName /set /y", vbHide
End Sub