Update underlying table by changing data in query dataset

I have two tables.  I have created a query creating a dataset with one field from Table A which is not updateable and several fields from Table B which I would like to update by entering data directly into the fields while I am viewing the dataset.  Is there a way to do this?
dur2348Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Open the query in design view.
Bring up the Property sheet
Set the Recordset Type property to 'Dynaset (Inconsistent Updates)'

mx
0
 
dur2348Author Commented:
Thanks for your help!!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome.

Please ... with that setting I showed you ... be VERY careful - and be sure that you are updating exactly the fields you want - not for example, updating the One side of a one to Many relationship that has Cascade Updates enabled - etc.

mx
0
 
dur2348Author Commented:
Thanks for the further information.  I will only be updating the many side of the relationship and I will be testing it for a time before it goes live.  Thanks again.
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.

All Courses

From novice to tech pro — start learning today.