Sinchronize date with server's date

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Would you please help me solve date/time problem
synchronizing date/time in client and server?
Date and time is critical in the system because the client
can change system date any time.
Thank you.
 
With an Oracle server I use the following to avoid exactly that problem :-
Create a view on the server as SELECT sysdate FROM dual ;
Link the view to Access.
Use my own functions SysDate and SysTime to retrieve the appropriate parts of
the time everywhere that Date() or Now() would normally be used.

You should be able to do something similar whatever your server is, just by
changing the view to suite.

You might also consider using NTP if you have a permanent internet connection,
though that does not prevent deliberate interference with the client time.
 
If you're using SQL Server use getDate(), it brings Date (mm/dd/yyyy
and time (hh:mm:ss) to you.
If not, just use whichever function exists on your server.

There is a simpler way of synchronizing. Why not ask for the networ
administrator to synchronize it using Active Directory ? If there isn'
one, try to make them create, its very simple.

And disable the user's permission to change date/time on their ow
computers
 
Back
Top