Weird Error Msg .....

[Peter chin]

Hi, There,

Please help to find out the solution for this error message in the order
entry screen when they save and confirm the order.

Error msg :

"The microsoft jet database engine stopped the process because you and
another user are attempting to chnage the same data at the same time."

FYI, there is no other people accessing the same records, that really makes
have no ideal for what this msg try to mean ....

Please ask your friends for their opinion and solutions......

Rgds,

Peter.

 

[Douglas J. Steele]

Sometimes you can be the other user!

For example, if you've got two different forms open at the same time, and
both have data from the same table.

 

[Peter chin]

Thx Mr Douglas,

One more advice request your help,

My order entry screen design has a form and subform. main form record source
is
order header and subform is order detail.

The database design set is exclusive in user side which user has one copies
as front-end and the actual database is store in server as back-end.

when the user try to save and confirm order data it will prompt that error
msg, as you advice that maybe i'm the user that causing the trigger of below
msg, is it something wrong with my screen design ?

P/S: The message is happened on and off not all the times, that makes me
hard to find which r the possible cause of it ....

Thx for reading this lengthy message n hopefully can get your reply soon.

Rgds,

Peter.

 

[Guest]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting