If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Operation must use an updateable query" On UPDATE Only
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. -- Hmm...they have the Internet on COMPUTERS now! |
#2
|
|||
|
|||
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 "MDW" wrote: 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. -- Hmm...they have the Internet on COMPUTERS now! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Operation must use an updateable query?? | Steve S | Running & Setting Up Queries | 2 | March 17th, 2005 12:42 AM |
Update query to resequence | MSROOKIE | Running & Setting Up Queries | 2 | March 7th, 2005 01:11 PM |
"Operation must use an Updateable Query." - How do I get round this? | John Ortt | Running & Setting Up Queries | 1 | November 10th, 2004 12:04 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Operation must use an updateable query | Gordon | Running & Setting Up Queries | 2 | June 17th, 2004 02:31 AM |