Need to pull Sql Server time to my access app...Help!

[Labadore]

I've created a timesheet app that will keep track of all employees during the day. When they clock in or out it uses the now() function to read the system time and inputs it into the fields. The employee's have decided they can change the system time to what they want then clock in. So what I need to do is somehow read the Sql Server date and time and input that into a field. If anyone knows how to do this or has done it before please let me know how.
Thank you in advance for all your time and help.

labadore

 

[jonscott8]

The GetDate function returns the current date/time in SQLS.

You can return it like so:
SET oConn=CREATEOBJECT("ADODB.CONNECTION&quot
SET oRS=CREATEOBJECT("ADODB.Recordset&quot

oConn.Open "MyDSN","MyUserName","MyPassword"
If oConn.State = 1 Then
SET oRS = oConn.Execute("SELECT GETDATE()&quot
MsgBox "SQLS Date/Time is: " & oRS.Fields(0).Value
End If

Or you could set the default value of the field in your SQLS table to Getdate(), so when you do your INSERT, the field is updated with the server time. Jon Hawkins