Help, please about - must use updateable query statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got the error message "Must Use Updateable Query operation" when I tried to
update or add a new record on Access 2000. The same application works on
other computer with the same MDB. Does anyone has any solution for this
problem?

Thanks!

Slw52
 
I got the error message "Must Use Updateable Query operation" when I tried to
update or add a new record on Access 2000. The same application works on
other computer with the same MDB. Does anyone has any solution for this
problem?
Click to expand...

Are you using different versions of Access on the two computers? As
new versions have been released they've gotten stricter about what's
updateable and what's not. Also, if these are two different .mdb files
containing the tables, the indexing may be different; you must have a
unique Index on the "one" side table's joining field, and a nonunique
index (such as that created by using the Relationships window and
enforcing relational integrity) on the "many".

If it's not clear why the query isn't updateable, please open it in
SQL view and post the SQL code here.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top