P
pbrase
I have a massive batch update process which reads in data from a file,
creates a record for it in a master table, and then depending on certain
values in that record, also creates one or more child records in one or more
of 8 related tables. I use ADO recordsets to manage the Access tables, and
all processing is done via a VBA module. In my testing I have been plagued
by random occurrences of the error in the subject line. I am the only one
using this database. On various test runs using the same data set I have
received the error at random points so there doesn't seem to be an actual
data problem. I have tried adjusting the lock property of the recordsets and
also have tried disconnecting and reconnecting the recordset after each
insertion, all to no avail. If anyone can shed light on this, it would be
greatly appreciated.
creates a record for it in a master table, and then depending on certain
values in that record, also creates one or more child records in one or more
of 8 related tables. I use ADO recordsets to manage the Access tables, and
all processing is done via a VBA module. In my testing I have been plagued
by random occurrences of the error in the subject line. I am the only one
using this database. On various test runs using the same data set I have
received the error at random points so there doesn't seem to be an actual
data problem. I have tried adjusting the lock property of the recordsets and
also have tried disconnecting and reconnecting the recordset after each
insertion, all to no avail. If anyone can shed light on this, it would be
greatly appreciated.