ServerTime

  • Thread starter Thread starter chris
  • Start date Start date
C

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
 
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
 
Back
Top