Update In Access

[Big X]

Hi,

When I receive data for mail outs I separate good addresses records from bad and send the bad ones back to the customer who then updates them and sends them back to me. What I want to be able to do is when I receive the records back is to update them into the table I have over writing the old records(bad records) with the new ones. Using the design query window I have brought the new record table in and select update query option. I cant see a way of updating the new records table into the old records table. Any help would be appreciated.

[nico5038]

When you have A2007 you can use the SharePoint server fuctionalit, for the oder versions VBA code is needed.
First make sure that the unique ID is in the messsage and all the fields needed in a "fixed" way. This will enable you to extract the fields by using a Split command and processing the resulting table.
Are you familiar with VBA code ?

Nic;o)

[Big X]

Not really I just wanted an easy way to update in access. From what Ive been reading I can do a query in access with the old data in design view then put in the update attribute boxes [FIELDNAME].[TABLENAME] . That is an easy enough option I guess but its a bit of a pain if there a lot of fields and no drag and drop option.

[Big X]

That option does not seem to work with the field name. I just got it from Microsoft help updating table with a table. In the end it isn't a big deal. The way Ive been doing the jobs at the moment is I run certain query to find bad addresses then mark them in a column. I then run a query to retrieve all bad addresses and create a CSV for the customer which they update and send back to me. I then run a query on the original table to produce good addresses and do the job. Then I import the returned CSV as a table and produce those last addresses separately. Would just be nice to be able to put the data back into the original table to eliminate runnning to seperate jobs so to speak.

[nico5038]

You don't even need a query, just open the table and right-click the field you use for marking a bad address, then select the "Filter including" or "Filter excluding" depending on the value you want from the pop-up menu.

Nic;o)