I have an Insert query that runs beautifully in Access 97 but fails to produce any results when run from VB6 using ADO 2.5 Command.

I've figured out what the problem is, but I haven't figured out the solution.  The query contains the clause...

WHERE DEALER = "This Dealer" AND INVOICE_TYPE LIKE "Tax*"

If I remove this from the query it run's, but it's pulling too many records.

I've tried the Providers MSDASQL.1, Jet OLEDB 3.51 and 4.0.

I've tried the following strings

WHERE DEALER = 'This Dealer' AND INVOICE_TYPE LIKE 'Tax*'
WHERE DEALER = """This Dealer""" AND INVOICE_TYPE LIKE """Tax*"""

The query executes without error, takes a few seconds, but the database is not updated.  Anyone else come across this?

PS. This is also listed under the VB Forum