I am guessing here, but I think the auto refresh feature bundles 2 SQL command via the provider. That's why the multiple step error. Again this is still just guessing, but the VFP provider may not support this. I will check it out and see if I can get it to work against the Northwind DBC. I know it works with Oracle and you can bet the farm it works with SQL Server.
>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.
Mark McCasland
Midlothian, TX USA