Error when running database.Execute(DELETE FROM ...) in DAO
Posted on 2002-05-04
I have a database that I need to delete records from. The deletion is based on the customer number which is a dbLong and an dbAutoIncrField as well as an index field. Here is the execution method I am using
mydb.Execute ("DELETE FROM [Clients] WHERE [Customer Number] = " & Chr(34) & custNum & Chr(34))
I can get it to work using the other fields like last name or first name but it specifically has to be done using the customer number. The error I am getting is
Run-Time Error '3464':
Datatype mismatch in criteria expression.
The customer number is not blank and it is known. More points for extra effort.