How can i retrieve Server side DateTime from MS Access.
Can anyone help me with the complete query.

it would be great

Kuldeep

Why do you need the server side date time?
At login, you should be running a script so that the workstation clock gets set to match the server. Then you can just check the clock on the workstation.

When a file gets saved to the server, the date stamp comes from the workstations clock, not thr server. That is why it is a good idea to have all workstations that log onto a file server update their clock to match the server's clock.


Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

If the back end of the database is stored on a file server, just use Date() and Time() or Now() to get this info. It comes from the file host machine. So if the Back End is on the server, it "should" take the server time.

Try setting the front end machine's time to something different from the server time, and then create a record using Date/Time defaults and see which time you grab.

I agree about having the workstations update their clocks from the server. If you are doing record prioritizing based on a timestamp, then they should all be getting their time from the server.

HTH

mmcdonal