Solved

Updating a master file in Access

Posted on 2012-03-28
2
246 Views
Last Modified: 2012-03-28
I have a table with a list of employee records, each identified by a unique id, and there are 9 other fields on the table.  There are around 25,000 records.  I have to maintain this master table as updates to the records are submitted to me.  The structure of the update tables is the same as the master table and between 1 and 9 of the non employee id fields may have changed.  Is there a query that can be run to elegantly update the master table?  Please see attached for a sample of the master table and update table.
EE-update-master-file.mdb
0
Comment
Question by:GIStewart
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 350 total points
ID: 37777235
If you are always going to get all fields then just update all fields.

Update Master as M Inner join  [Update] as U on
M.Employee_id = U.Employee_id
Set M.flda=u.flda, m.fldb= u.fldb, M.fldc=u.fldc, m.fldd= u.fldd,M.flde=u.flde, m.fldf= u.fldf,
M.fldg=u.fldg, m.fldh= u.fldh,M.fldi=u.fldi, m.fldj= u.fldj
0
 

Author Comment

by:GIStewart
ID: 37778008
thank you
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
count unique records in access report 2 23
Help writing a query 6 72
Update fields from multiple tables via same form 2 24
Web based Access Database and licencing 5 29
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now