| Allen Browne 2005-04-27, 9:24 am |
| 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\msacce
ss.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
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John" <John@nospam.infovis.co.uk> wrote in message
news:u53N2WzSFHA.628@tk2msftngp13.phx.gbl...
>
> 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?
|