A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Operation must us an updateable query



 
 
Thread Tools Display Modes
  #1  
Old October 29th, 2008, 10:04 PM posted to microsoft.public.access
David9746
external usenet poster
 
Posts: 8
Default 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  
Old October 29th, 2008, 11:31 PM posted to microsoft.public.access
ntc
external usenet poster
 
Posts: 130
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.