Error adding a new detail record

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have a master/detail form with detail part being a sub form. My problem is
that when a user clicks on the sub form to add a record, this error comes
up; "The Microsoft jet database engine stopped the process.because you and
another user are attempting to change the same data at the same time.".

What is the reason for this error and how can I fix it?

Thanks

Regards
 
The error can be cause by a genuine concurrency problem. For example, you
may have another form, query, or recordset open where you are editing the
same record, or you may have two copies of the database open, or another
user may be editing the same part of the database or trying to modify the
same form you are using (if the database is not split). If there are BLOB
fields involved (Memo, Hyperlink, OLE Object), you can get the error even if
the other forms are not editing.

If you are convinced that there is no genuine concurrency problem, then the
symptom may indicate a corruption of the database. Try these steps, in
order, to recover it:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

If the problem persists and you are still convinced it is not a concurrency
issue, see:
http://allenbrowne.com/ser-47.html
 
Back
Top