An SQL statement that seems straightforward and has worked for months suddenly produces error -214721700 -- with the descriptor, Syntax Error in either "UPDATE" or "INSERT INTO...."
I'm using VB6 & ADO to work with an Access 2000 db.
This only occurs in the "First", and "Last" fields of tblCustomers. I can add or modify all the other fields --Phone, Cell, Company, Address, City, State, etc.
Have deleted and replaced the fields, altered all the field properties I can think of with no change in performance.
Searching the MS Knowledge Base doesn't seem to produce results that apply to Access.
By the way, the statements work just fine in Access 2000 (query builder) itself.
Arrggghhh! Any suggestions?