CODEWITHSUNDEEP
sqlvbams-access
Bernard Faucher
Bernard Faucher

Reputation: 149

Error 3073 in an update query that has been working

I made an Inventory Count application that has been working for the last five years.

Today, I am getting errors with an update query in VBA.

Here is the query definition:

StrSQL =          " UPDATE Ticket "
StrSQL = StrSQL & " SET Ticket.[FirstCount] = [Forms]![ExistingTag]![FirstCount], "
StrSQL = StrSQL & " Ticket.[FirstCountEntered] = True "
StrSQL = StrSQL & " WHERE (((Ticket.Ticket)=[Forms]![ExistingTag]![Ticket])) "

I get the following error:

Operation must use an updatable query. (Error 3073).

Upvotes: 1

Views: 131

Answers (1)

Julen
Julen

Reputation: 329

If you have recently changed the database schema or code, undo that changes and try again.

If not, as it seems for your question, consider the possibility that the Access database has become corrupted. In fact, that error That happens. Recover it (Compact and Recover is called lately). In fact I really recommend setting all "code" databases to compact on exit. Even so, there is the possibility that corruption remains. Then you have to use a copy to see if it fails.

This problem can also derive from a full disk or because you are using a remote database file and you have no permissions to write to it. Try to isolate the problem creating a new database (and data-database if you have the concerns separated, as you should) and trying to reproduce the error by copying the needed forms-tables from the failing databases.

These would be my first steps in this case.

Upvotes: 1

Related Questions