Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

updateable query

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I keep getting the error Operation must use an updateable query. when i trry to insert data to database from a form.
What does this mean?
thanks for any help

 
billyb,
Two of the most common reasons for this problem are that

(1) the table you are trying to update does not have a primary key defined or

(2) your form is based upon a query that does not include the primary key(s) of the underlying table(s).

Of course, there are several other possible causes, but these are very common and are simple to fix.

Paul
 
Was your problem solved by tweaking your database?

If not, and issue is still live for you, submit your code for review.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top