Opened Exclusively?

[Julia82]

Hello all,

I am encountering this problem when I try to update a table using this:

DoCmd.RunSQL "UPDATE tblUser SET strPassword='" & Me.txtRenew2.Value & "'
WHERE [UID] = " & Me.UID & ""

Gives me this error:

Run-time error '3008'

"The table tblUser is already opened exclusively by another user, or it is
already open through the user interface and cannot be manipulated
programmatically."

The table is closed. I have just this form opened. What can I do to solve
this error?

I tried to find out what this error means and I found out that has to do
something with the frontend and backend interface or something like that, but
I don't know what that means.

Any help is very much apreciated!
Thank you!

 

[Julia82]

Wow, thanks alot for all your help. I didn't figured out what is the problem
yet. Maybe someone knows this issue?

Thanks...