Errors 3073 operation must be an updateable query

[Jeff]

Hello,

I have designed a multi user application, where I have 1 MDB as the Client &
another which holds the data & is placed on a networked Drive.
The client has the Linked Tables to the Network one.

At random times when some users try to do something in the program this
error message appears:
"Error: 3073 operation must be an updateable query."

It is hard for me to pinpoint where it is happening exactly becuase it is
only happening at the clients site.

I believe it happens when this Query is being run:

strSQL = "UPDATE tblProposals SET BeingEdited = True, " & _
" BeingEditedBy = " & Chr(34) & gstrCurrentUser & Chr(34) & _
" WHERE ProposalNumber = '" & _
Form_subfrmProposals.txtProposalNumber & "'"
DoCmd.SetWarnings False
DoCmd.RunSQL (strSQL)

There doesnt seem to be anything wrong with the Query.

Does anyone have any ideas what may be causing this error ?

Any help would be greatly appreciated.

Thank you,
Jeff

 

[John Smith]

It would suggest that tblProposals is not updatable. If it is just a linked
table, rather than an access query, I have many times had Access decide to
throw away the key definition for linked tables which makes them
non-updatable. In this case restoring the key fixes the problem.

HTH
John