I'm having trouble trying to delete multiple rows from Access 2000 from VB 6.0 using ADO.
Single row deletes function properly, but 2-N row deletes generate:
Run Time Error 3219 Operation is not allowed in this context
The code is as follows:
' Connect to the database & table
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TestData\Contact.mdb;Persist Security Info=False"
.RecordSource = "Consultants"
' delete records
.Filter = "CurrentEmployer like 'Smith%'"
The error is generated on the .Delete command. I'm trying to remove records from the table and would prefer to use one command instead of writing a "For...Next" or "Do...Until" loop to remove the records.