I'm running a large update/append query, with 90 fields being updated. If there are any more than about 100 records in the Update table I get the following error:
"The MS Jet DB engine stopped the process because you and another user are attempting to change the same data at the same time."
The database is on my local machine, and there are no other users...
If I put fewer records in the Update table, it will run, or if I remove some of the fields to be updated (down to 42) it will run with any number of records in the Update table.
Help!!!
Erik
"The MS Jet DB engine stopped the process because you and another user are attempting to change the same data at the same time."
The database is on my local machine, and there are no other users...
If I put fewer records in the Update table, it will run, or if I remove some of the fields to be updated (down to 42) it will run with any number of records in the Update table.
Help!!!
Erik
