• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

ms access + query - adding table makes it not updatable

i have a query that returns a datasheet, and then get an message that says the recordset is not updateable - i have narrowed it down to one of the tables, if i remove the table i can update the fields, if i add the table i cant, the table has a relantionship to the main table, i cant figure out what the problem is - any suggestions on what i can look at to fix the issue.
0
dkilby
Asked:
dkilby
1 Solution
 
Rey Obrero (Capricorn1)Commented:
see this link

When can I update data from a query?
http://msdn.microsoft.com/en-us/library/aa198446%28office.10%29.aspx

in most cases, as stated in the link
setting the forms recordsettype  to Dynaset (Inconsistent Updates). will do the job
0
 
dkilbyAuthor Commented:
excellent - that was easy fix - thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now