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

OK another odd question.

100+
P: 434
I've put to tables together with a query, now when I try and update the query it will not update. Is there something I'm missing. The query is joined together by a common column. Is there something in a query I need to set to make it so I can edit it? I've checked the properties and there is no locks, the join properties is set to the 1 I've tried both the two and three options and still nothing.
Again thanks for all your help.
Feb 3 '14 #1

✓ answered by Rabbit

Not all queries are editable. It's hard to say why when you haven't shown us the query but you can read more about it from Microsoft here: http://msdn.microsoft.com/en-us/library/aa198446.aspx

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,315
Not all queries are editable. It's hard to say why when you haven't shown us the query but you can read more about it from Microsoft here: http://msdn.microsoft.com/en-us/library/aa198446.aspx
Feb 3 '14 #2

100+
P: 434
I went back and looked at the two tables, set the link column to the primary key and that seem to do the trick. Thanks for pointing me in the right direction.
Feb 4 '14 #3

Post your reply

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