Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Update underlying table by changing data in query dataset

Posted on 2008-06-10
4
Medium Priority
?
252 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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

604 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