Microsoft Jet Database engine stopped the process - HELP

[Hap007]

Help, this is driving me crazy!!!

I have a form that creates an Order Header and one or more order detail lines

The main form has an entry into a local table (Header record)
The main form also has a sub form, that is attached to second local table.
Detail lines are entered into the second local table.

When the user presses my save button, a query reads the local tables and adds these records to the shared backend and then deletes the local records and is ready for the next order. All works and is good 99 percent of the time.

Problem....
Every once in a while, when a detail line is being entered, I can enter all the items, but when I move to the next detail line I get this message:

The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the data at the same time.


Trouble is, This is a local table and I am the only one entering the data.

This is an intermitent problem. The error can show up on the first order or it might be the 10th order or it might not show up for a couple of days.

I have tried everything. I have error messages every where, but this Access Error message is from Access itself not my code, I have a tough time even 'breaking' to get into the code, and if you leave the error message up, it starts repeating the same message. Seems that when it does happen, it is the first entry of the detail table.

Notes: Access 2002 XP with service pack SP3 applied.

Any suggestions?

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[lameid]

I'll through some guesses into the pot...

The handful of times I have used local 'temp' tables, I always used a local backend for them. That way the frequent write and deletes will not interfere with the application objects (corruption). I would copy the backend database local as part of a process that used the tables, but in your case I would do it on startup (autoexec macro / startup form's On Open Event).

I am not convinced that it is corruption though. It sounds more like a locking problem. Maybe setting Record Locking would help? Are you sure the main form's record is commited before going to the detail... Or at least saved once so that the FK is available for the referential integrity you probably have set. Maybe you have events firing that interfere with the save.

I hope this is helpful. I am curious as to what is causing it.

 

[Hap007]

Hi,

Well, I have been playing with this for over a month.
Originally, no locking, now a query with locking.
Originally, did save of primary record, took that out.
I placed DoEvents every where
I placed 'Error ' messages every where.

I have tried so many things.

The problem, it will work for a day or 2 then fail
It will work for an hour or 2 then fail
It will fail first time run, then will run fine.

No pattern, just happens sometimes.
Seems if the first sub form record gets written and you move off the record to the next record, that is where it fails. Once the first record is saved, it does not seem to fail as you add additional records, just seems to fail moving from the first to second, but not always.

Any other thoughts.

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Hap007]

Hi All,

Well, after altering the code in a dozen different methods, I finally found an article on MSDN that described my exact problem on a terminal server workstation.

Seems that the same problem also can occur on a Windows XP box, but is not documented as such....

So, Office / Access XP SP3 did not resolve, but
this Jet 4.0 HotFix from Microsoft did the trick.

Here is a link if anyone else has a similar problem:

http://support.microsoft.com/kb/895751/en-us

Hope this helps someone else
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Lhuffst]

Thanks for the information. I"ve been struggling with this for 2 days and this sounds like the answer I need.
Lhuffst