Reserved error (-1038) when Updating > 109 fields in Access 2000/ SQL7
Posted on 2002-04-01
I have a table with 150 fields, and I'm importing data from a linked dBase table into a linked ODBC
SQL7 table (tried file dsn and machine dsn).
I created recordsets for the fields in both tables, and when I set the [SQL_field] = [dBase_Field]
on fewer than 109 fields, it Updates fine. But Updating after the 109th field causes an error:
"Reserved error (-1038); there is no message for this error"
KB has a reference to this error number, but this is an Access 2000 program and never was in Access
97, nor was it ever replicated, so that article is useless (but the error message is identical).
This happens on several machines.
Access 2000 (Developer)
msjet40.dll version 4.0.3714.7
windows 2000 pro
Any ideas what is causing this error??? Thanks!