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 us an updateable query
I have an update query with 2 tables joined by a Key field. One of the tables
is a linked table from an sql server and the other table resides locally in the database. I am trying to update the local table with the data from a field in the linked sql table but i keep getting the error message "Operation must us an updateable query." Strange thing is this query was imported from another database and it is using copies of the same local table and yet it works fine in the other database with the same linked sql server table. I don't know why since the table it is trying to update is not opened read only nor is the databse opened read only. I would appreciate any thoughts on this. Thanks David |
#2
|
|||
|
|||
Operation must us an updateable query
an updateable query is a state unto itself - and doesn't mean the table or db
is read only the table/db may be read only if you have Access2007 and have not established the Trust location. any query may be not updateable if the database considers the join/design to be able to apply an update to multiple records. rather than import this query....copy/reuse the same front end where it is known working.... or if that is not possible; search on the topic of updateable queries - you will see good advice on this issue. "David9746" wrote: I have an update query with 2 tables joined by a Key field. One of the tables is a linked table from an sql server and the other table resides locally in the database. I am trying to update the local table with the data from a field in the linked sql table but i keep getting the error message "Operation must us an updateable query." Strange thing is this query was imported from another database and it is using copies of the same local table and yet it works fine in the other database with the same linked sql server table. I don't know why since the table it is trying to update is not opened read only nor is the databse opened read only. I would appreciate any thoughts on this. Thanks David |
Thread Tools | |
Display Modes | |
|
|