creating a log file with MS Access

  • Thread starter Thread starter snipersix
  • Start date Start date
this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());
 
snipersix said:
this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());
Click to expand...

CurrentUser is a function so you need the () on the end just like you have after
Now().

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser(), Now());
 
Back
Top