Help, please about - must use updateable query statement

[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

 

[John Vinson]

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?

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