I have a query that captures the userid when then enter a form in Access 2003 and appends that into a logon table so i can see who logs on and when they leave as well. One user gets the "operation must use an updateable query error" error when he opens the DB. I coulbn't find an answer to why this is happening in the forums. No other users get this error. below is the sql for the query that runs on open.
INSERT INTO tblLogon ( Userid, LogonTime, Machine )
SELECT fosusername() AS Userid, Now() AS [Time], Cnames(2) AS Machine;
Thanks.
INSERT INTO tblLogon ( Userid, LogonTime, Machine )
SELECT fosusername() AS Userid, Now() AS [Time], Cnames(2) AS Machine;
Thanks.