Re: Comparing two DataSets with a Merge

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mark Rae (mark_at_mark-N-O-S-P-A-M-rae.co.uk)
Date: 12/09/04 

Date: Thu, 9 Dec 2004 16:26:28 -0000

"Joe Sullivan" <JoeSullivan@discussions.microsoft.com> wrote in message
news:757BC859-52F2-4695-8F7A-50E59C9CBEF4@microsoft.com...

> What I am attempting to do is update data on our live sql server that has
> been changed over time offsite and saved in an access database. I can't
> just
> call the GetChanges() method of the dataset because I want to make sure
> that
> I get all changes across multiple runs of the application (this is an
> offline
> application that may not always be running).

In a nutshell, are you trying to fetch a dataset from one recordsource and
then see if each record exists (by primary key comparison) in another
recordsource? If not, then add the record to the destination recordsource,
if yes, then update the destination recordsource with the values from the
source recordsource?

If so, then I have just written exactly that for mySQL and SQL Server, but
the code should be virtually identical...

Relevant Pages

  • Re: New coder, need help getting started - How do I set a ADO record set?
    ... property of the form, use the name of a table or query, or use an SQL ... You can also build a recordset using DAO or ADO, and change the recordsource ... I would like to link an Access database to a form, ... How do I set up a ADO dataset to link to my database ...
    (microsoft.public.access.gettingstarted)
  • Re: Display data from ODBC table
    ... Originally the Form's RecordSource was pointing to just the original table. ... I changed the RecordSource to be a query to merge the original table with the ... >> I am trying to display the data from an imported ODBC table. ... >> table in my access database, ...
    (microsoft.public.access.forms)