Operation must be an updateable query! Arg

[redbull]

Alright, I have a front end, and a back end. Everytime a user clicks a front end button, the function does an insert query to the backend thru this query...

INSERT INTO tblFuncLog ( chrUser, chrFunction, dtmTimeStamp )
SELECT Environ("username") AS Expr1, [screen].[activecontrol].[name] AS Expr3, Now() AS Expr2;

We are running into a problem with SOME users they are receiving the message

"Operation must be an updateable query"



I am very lost, any assistance would be appreciated.

If I can help by providing anymore information please let me know.

[June7]

This is a saved Access query, not VBA constructed SQL?

AFAIK, Access does not recognize Environ() function, VBA does. So put the function in a custom function and call the UDF from the query

Public Function GetUser()
GetUser = Environ("USERNAME")
End Function

INSERT INTO tblFuncLog ( chrUser, chrFunction, dtmTimeStamp )
SELECT GetUser() AS Expr1, [screen].[activecontrol].[name] AS Expr3, Now() AS Expr2;

[redbull]

Hmm, well I have this in the vba code

Public Function Environ(username)
On Error GoTo Err_Environ


Environ = VBA.Environ(username)


Exit_Environ:
Exit Function


Err_Environ:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_Environ


End Function

So I am going to try your code, see what happens

Edit - Yes it is a saved query in access

[redbull]

Alright, so it is working on my machine. Once someone comes in that was receiving the error comes in I will deploy/test/report the results. My question is why would this error ONLY be happening for certain users?

[June7]

All using the same version Access and OS?

I would not give a UDF same name as intrinsic function.

Your original function has wrong syntax for VBA.Environ(). USERNAME must be within quote marks. Otherwise, triggers run-time error 5. The error handler should deal with that but not sure what is happening.

[redbull]

Alright, I just tried on one of the users machines. Odd thing, when the FE was an MDB it worked fine with your code. HOWEVER, when it was an mde the same error message occurs.

[June7]

Sorry, no experience with MDE, never converted db.