Currrent date from server

[Ricoy-Chicago]

Access XP. The main date entry in the F/E file contains a date field where
the user type today's date.
Management wanted the date to show automatically. No problem I used date()
and locked the box. The problem is that the user can change the date in
his/her computer, therefore the date changes in the records. Since the date
in the server cannot be changed by the users, is there a way to pass the
server's date to date field?

Thanx.

 

[Jerry Whittle]

Do you have user-level security enabled and access to that table locked
tightly down? If not, there's nothing to stop the users from changing the
date no matter what the computer or system server says.

My rule of thumb is if you can't trust a user to not forge data, fire them.

 

[Jeff Boyce]

If you are using a SQL-Server back-end, I believe you can use the GetDate()
function (in SQL-Server) to do that.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ricoy-Chicago]

What I am looking for is a way to lock the date/time feature in the
computer's task bar. I will try a different discussion group.

Thanks for your help.

 

[Albert D. Kallal]

Actually, there is a way to get the date:

http://www.mvps.org/access/api/api0039.htm

the above works with windows xp, or windows 2003 as an server