By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,825 Members | 2,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,825 IT Pros & Developers. It's quick & easy.

Problem with linked table

P: 1
I have two Exell linked tables, i want to update the one with information from the other one. I made a Update Query and when I run the Update Query to update the data on my linked tables, I got a message saying: "Operation must use an updatable query".

When i dont link the tables and just import the tables the same Update Query works.

Any ideas how can I resolve this problem?
Sep 2 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Could you post the SQL for your update query? The use of linked tables in Excel of itself should not stop a query from being updatable. Unfortunately, Access can be quite picky about what it considers updatable, and including just one calculated aggregate (a total of some kind, say) will render a query non-updatable. As another example, selecting the key from the 'wrong side' of a 1-many relationship will render a query non-updatable.

In the meantime until you post the SQL for your update I suggest you look at the following item from the the Microsoft Knowledge Base which provides a full list of circumstances in which Access tables are not updatable.

-Stewart
Sep 2 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.