Try the ODBC provider MSDASQL. Or a regular ODBC DSN as your connection string. I've gotten the same error messages when using the native SQL provider. Now what is the (1) for? I don't see any reference on ADO where the Delete method would accept any parameters.

I will try the odbc drivers and let you know.


The delete method takes a parameter
#DEFINE adAffectCurrent 1
#DEFINE adAffectGroup 2

adAffectCurrent = Default. Delete only the current record.
adAffectGroup = Delete the records that satisfy the current Filter property setting. You must set the Filter property to one of the valid predefined constants in order to use this option.