>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.
You're right. I guess I should have said: "haven't used it any other way". Thanks for the heads up.