"Operation must use an updateable query" On UPDATE Only

M

MDW

Hey all,

I'm working on Access 2000, linking to a SQL Server 2000 table. When I try
to run INSERT commands through Access, everything works OK. But when I try to
make an UPDATE, it bombs out with an "Operation must use an updateable query"
error.

I can't think of a reason why one would work and the other wouldn't. I'm not
an expert at SQL Server, but when I go into Enterprise Manager and view
permissions for the table in question, it looks to be set up the same as a
different table that I CAN run updates against. I'm confused.
 
O

Ofer

It could be that your update query has more then one table, try and change
the properties of your query.
in the properties change the UniqueRecords Property to true, and try
 
Top