I changed the Connection String to the VFP OLEDB added the table but I get an error on the Tableupdate. 1435 - "Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value."
I used "Provider=VFPOLEDB.1;Data Source=C:\tmp\A.DBC;Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE"
>The code below is ORACLE demo code I use to test these features. BTW, they work like a dream! Create you a presidents table with the structure like what I have in the CA below. Make the KeyID field an Identity field. You will also need to tweak the ADO connection string.