LarryDeLaruelle
Technical User
I am trying to populate an SQL table with data from an Access 97 database.
I am using the Recordset method to add the record, set some values and update/save. I get the ODBC Call Failed (error 3146) on the Update line.
One of the fields in the SQL table is a GUID identified as a unique identifier. In my Access view of that table I see it as a text field. One thing I tried was generating a GUID in a work table and assigning that value to the SQL table/field -- still get the error.
Any ideas on what I am doing wrong or even if I can do what I am trying?
Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org
I am using the Recordset method to add the record, set some values and update/save. I get the ODBC Call Failed (error 3146) on the Update line.
One of the fields in the SQL table is a GUID identified as a unique identifier. In my Access view of that table I see it as a text field. One thing I tried was generating a GUID in a work table and assigning that value to the SQL table/field -- still get the error.
Any ideas on what I am doing wrong or even if I can do what I am trying?
Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org