Jet database engine stopped the process

  • Thread starter Thread starter Anthony Guzzo
  • Start date Start date
A

Anthony Guzzo

I am receiving "The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the same data at
the same time" error.

Here is my background:
2 mdbs 1-Dataonly.mdb 1-FrontEnd.mdb

FrontEnd.mdb has linked tables to Dataonly.mdb. With an unbound form
I collect basic HEADER type information. This form has a bound
subform on it. The bound subform collects the DETAIL type
information. It is bound to a local temp table that mimics the fields
in the Detail table in Dataonly.mdb. I save with a two step process:
1. I build a a SQL Insert Into statement to insert into the Header
table and return the record number.
2. I loop through the local temp table building a SQL "Insert Into"
statement for the Detail table for each record in the local temp. I
run the SQL for each record in the temp local table.

I am using the "CurrentDb.Execute sSQL" command for both steps 1 and 2

On occasion I am getting the above error, why? I am the only one
using both MDB? I am really tired of not being able to find out why
this is happening.

I am programming for Access 2000 using Access 2003.
My user has Access 2000. They also get the same error message. Only
difference is that they have multiple people linking to the
dataonly.mdb. The Frontend.mdb is installed locally on each users PC.

Can any one help? Do I need to set locking differently? It is
currently set to "No Locks" for both the FrontEnd.mdb and
DataOnly.mdb.
 
I have had the same issue and it is driving me nuts. I get this erro
wioth windows 2000 server and terminal services.

I can post up the full analysis that we have done, but thought I shoul
ask if anyone else has also had this proble
 
Back
Top