date time from hosting pc

[raytrace]

hi. this is my first ptost of this forum. need help on date time issue. as i know, the now function is used to obtain the date and time of the pc on which the form is running on. i am looking for a way to get the time and date of the pc on which the database is residing. i am using it to timestamp inserted and updated records. i am using access 2003 and windows xp.

[geekgirlau]

Interesting question ... I'm curious as to why ...

Anyway, try this (http://scriptorium.serve-it.nl/view.php?sid=58)

[raytrace]

Actually the reason I want to implement is that in a multi-user environment you can control many aspects of your application. However, when using the timestamp it is important for me to have the accurate values all the time.

Also, if someone wants to mess with the system it would be very easy in the sense that they can change the date and/or time on their system and then execute a transaction (I hope this makes sense).

About the code: First of all thanks for the link. I went through the code and found out that it seems to get the job done, but not even close to the efficiency of the NOW() function.

The reason I think there should be such a function or method to derive the "server" date is that in Oracle we can use "Select date from dual;" (or something to that effect) to obtain the current date of the server.