We have a paradox Table with the following fields (Acct#,ClientName,LastName) where Acct# is the Primary Key and WE CANNOT CHANGE THE STRUCTURE OF THE TABLE. Acct# is a type A in Paradox that is like a VARCHAR type in SQL, you cna insert Numbers and Letters and we already double checked that the primary key is not duplicated.
We can Update, Delete or Modify any record but at the time that we want to insert a new record, we get the following error
"ERROR [HYS22] [Microsoft][ODBC Paradox Driver] The INSERT INTO statement contains the following unknown field name: 'Acct#'. Make sure you have typed the name correctly, and try the operation again."
The query is as follows -- INSERT INTO status([Acct#]) values('123123123'). We are almost sure that is because of the Special Character on the Acct# field.
Does nyone have a work around or a solution for this problem that can help us? We are migrating from Paradox to SQL and are struggling with this problem. Any help would be appretiated.