467,074 Members | 884 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

Updating MS Access tables

I am updating MS access tables with data in an xml
document. I create two dataset, one for existing data and
one for new data. I fill the first dataset with the
records from MS Access, the second with data from the xml
Document. Both datasets are populated properly. When the
new data contains records that exist in the existing
Access table but with changes in individual elements, the
matching records in the first dataset are not changed and
when an update is performed nothing is done to the
records in the Access table. However, if there are new
records with keys that do not exist in the Access table,
these new records are inserted properly.

I have tried every possible combination of parameters
with no success. Below is code:

ado.daItems.FillSchema(dsCurrent,
SchemaType.Source, "Items");
ado.daItems.FillSchema(dsUpdate,
SchemaType.Source, "Items");
ado.daItems.Fill (dsCurrent, "Items");

columnPosition = 34;
//Get modified date of last
record in Access table
lastModDate =
qbQueryClass.GetLastModDate(dsCurrent, "Items",
columnPosition);
//Retrieve records from
QuickBooks that have been modified since the last
modified date in Access table
qbQueryClass.GetNewRecords
(lastModDate, "ItemUpdateQuery.xml", "ItemRaw.xml", "Trans
formCombined.xslt");
//Read the new records
into a dataset

dsUpdate.ReadXml ("ItemUpdate.xml",
XmlReadMode.IgnoreSchema);

//Merge the dataset with
updated records with the dataset containing the Access
records.
dsCurrent.Merge(dsUpdate,
true, MissingSchemaAction.Error ); //have used all
possible MissingSchemaAction parameters here.

//Update the Access table
ado.daItems.Update
(dsCurrent, "Items");
dsCurrent.Tables.Remove
("Items");
dsUpdate.Tables.Remove
("Items");

dsUpdate.Clear();
dsCurrent.Clear ();

Nov 15 '05 #1
  • viewed: 1486
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Irvin | last post: by
1 post views Thread by Mark | last post: by
1 post views Thread by rdemyan via AccessMonster.com | last post: by
5 posts views Thread by aaron.m.johnson@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.