I need the time based on my back-end database...

[hhzyousafi]

I am currently using a front-end and back-end of Microsoft Access 2007 in a multiuser environment. I have approximately 30 users and I make extensive use of the Now() function which returns the current system time. Unfortunately I have noticed that some users have access to change their system time and as a result of this they can basically manipulate the time that is entered into the system. I need to tell my front-end to use the time of the server my back-end database is split on. Is there anyway to do this?

Gotta love end-users!

 

[Mihail]

This seems to be a solution
http://www.vbforums.com/showthread....m-Internet-Time-Servers&p=4078319#post4078319

I can't test but another idea is to implement, in the BE, a function that return the date.

 

[Galaxiom]

Never mind using the server time.

Talk to company management about a policy to instantly dismiss any employee who changes the time on their PC. Once the first one gets the marching orders I will guarantee the rest of them toe the line.