How do I remove the error I am having in Access

[Guest]

I am getting an error in my database that shows up as soon as I open a
certian form. It says "The Microsoft Jet database engine has stopped the
process because you and another user are attempting to change the same data
at the same time." Can I get rid of this problem, and if so how?

I also can not delete a record I have in the main table it just says I can't
delete the record because it can not find the search key. What is the search
key and how would I go about deleting this record?

 

[Arvin Meyer [MVP]]

It sounds very much like you are having some corruption issues. When was the
last time you did a repair and compact on your database?

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access