Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Operation must use an updateable query Error

Status
Not open for further replies.

BV874

Technical User
Nov 23, 2009
33
US
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.
 
I figured it out. it was the "write" option on the security for certain user groups in explorer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top