When I try to Insert a record from a central db (SQL Server, ver 6.5) into a local db (Access95) I get 'Error 3075 Syntax error in string in query expression...'. What causes this problem is one field in the record. This field is defined as Text in SQL-server and as PM in Access. Inserting the data from Access to SQL-server causes no problems. There are no problems to retrieve the record from SQL-server. The problem arise when I try to Insert the retrieved record into Access.
I use VB4 and ADO. I store the SQL-command in a string (sSQL) and then use:
M_dbDatabase.Execute(sSQL, dbFailOnError + dbSQLPassThrough)
as the "trigger" for the command. In the VB code the Text-type/PM-type field is defined as a string.
I really hope that someone understood my question and that someone has an answer to this problem.
Please make my month! :-)
Thanks in advance from a Frustrated Swede!!