Secured Time Card

[cpgospi]

This is my first time posting here, although I've had many a question answered browsing the forum thanks to all who donate their expertise.

Anyhoo, I have a production db that works great. Access2003 FE/BE. Win2k/98 Machines.

Currently, I have 2 forms which track time: Time Card & Job Logging

I have a request from a manager to secure the time tracking. A user can now change the system clock and log in/out at any time. Apparently, the honor system is being abused.

Any thoughts or suggestions would be much appreciated.

Chris

 

[ghudson]

Interesting question but not unique. I searched for "network clock" and here is a link to what I found... Network Clock

Not very many answers since you are not using Windows XP for then you could lock the desktop with a registry entry.

Rich posted a link to some code in one of those posts that should do what you want. I do not have time to test it so please post back if it works for you.

Obtain the time of an NT Server/Machine

 

[cpgospi]

Thanks very much for responding. I'll try it out and post back.

Regards,

Chris

 

[ghudson]

Thanks Rich for that link! It works great. Now I just have to wait for the day that I actually need to use this code in an application.

Chris, This is what you need to use in your db [along with the code in the link Rich provided] to change the users computer date and time to that of the server that they are logged into...

    MsgBox Now 'this tests the current PC date and time
    Date = ServerGetTime(Environ$("LOGONSERVER"))
    Time = ServerGetTime(Environ$("LOGONSERVER"))
    MsgBox Now 'this tests the current PC date and time

Just call it in the event [button click] that the user runs to store their time in and out records so that you are synching their PCs date and time with their server right before you save their records. I bet that you surprise a few unscrupulous folks until they figure out what is happening. Now you just have to ensure that the date and time is always accurate on their logon server.

 

[cpgospi]

Now you just have to ensure that the date and time is always accurate on their logon server.

Imagine their surprise when I set the server time a few minutes ahead in the AM and back in the PM.

That's exactly what I needed. I haven't plugged it in yet, but I will give it a go this afternoon.

I'll let you know how it turns out.

Thank you again for your help & have a nice weekend.


Chris

 

[The Stoat]

If you wanted to be really nasty you could check the machine clock against the server clock and if they were more than a few minutes out dock them say... 4 hours

 

[cpgospi]

If you wanted to be really nasty you could check the machine clock against the server clock and if they were more than a few minutes out dock them say... 4 hours

Thanks for the suggestion but the guys using the db are about twice my size and I'd like to avoid the 'Danny DeVito in Taxi' situation.

 

[cpgospi]

Thank you!

Works perfectly.

GHudson, thank you again, very much!

Chris

 

[ghudson]

I am glad it worked for you.

Rich gets the credit for posting the link [with the code] I found.