Errors 3073 operation must be an updateable query

[Guest]

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

 

[senthamilselvi]

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

hi,
i am facing the same problem, did jeff got this fixed, if yes, pls can u mail the steps u did to fix this to (e-mail address removed)
thank you