Solved

Update underlying table by changing data in query dataset

Posted on 2008-06-10
4
246 Views
Last Modified: 2010-04-21
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?
0
Comment
Question by:dur2348
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 21753876
Open the query in design view.
Bring up the Property sheet
Set the Recordset Type property to 'Dynaset (Inconsistent Updates)'

mx
0
 

Author Closing Comment

by:dur2348
ID: 31465876
Thanks for your help!!
0
 
LVL 75
ID: 21754545
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
 

Author Comment

by:dur2348
ID: 21770874
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
default value of combobox 25 67
Delete table fields 3 44
Access Report Print Preview locking up the screen 14 49
question about a text field with default value 5 26
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question