access (runtime)

Topic

New Reply

Many of our user are getting an error message when working in access runtime. The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at he same time. Does anyone have an answer. Please help! We have the database split frontend backend. It was created in access 97. We converted it to access2000. This is how the problem started.
Thanks, Marie

Reply | Quote

Replies

Look for missing references in your 2000 mdb file.

Open any module. Select Tools / References.

Reply | Quote

You appear to be getting an edit collision. What kind of locking scheme are you using?

Reply | Quote

The error message you described often indicates corrupt record or records. Recommend refer to following MS Knowledge Base articles:

ACC: Jet Database Engine 3.x Error Messages Due to Corruption (Q182867)

ACC97: Concurrent Appends to a Memo Field Can Cause Corruption and Produces the #deleted Symbol (Q235391)

Note that the articles refer to Access 97, but I

Reply | Quote

Hi Marie

I had the same message, in my case I think the problem was caused by using too many memo fields.

I have a master record and six detail tables attached to a 7 tab form with six sub forms

The master record has 5 memo fields and each six subforms each had a memo field (this design was a carry over from a working dbase system)

I simply changed the memo field in the six detail table and sub form to text 255 in len and the problem went away. I did’nt touch the memo fields in the master record.

In my case 255 was enought space to hold the memo data.

If you do a forum search on your “error message”, you will find solutions from charlotte and others.

Aparently memo fields are stored differently and can share the same page as other memo field in the record set, this message has happen to me in a single user environment

HTH

John

Reply | Quote