Can not open database (error 3197)

[kunyok]

I have an access file that only use everyday by my sister.
Today when she tried to open the file this came 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. (Error
3197) "
I had tried to repair and compact database without success.
This file is front and back end in itself.
I use access 2003.
Please, need help.

 

[gil]

You have first to restart your computer

 

[kunyok]

OK, I restarted already.
But still can not open the file.

"gil" เขียน:

 

[kunyok]

OK I have restarted the machine.
But still I can not open or repair the file. Any suggestion.

"gil" เขียน:

 

[gil]

first delete the file databasename.ldb
and try

second Import your database in a new one

 

[kunyok]

There is no .ldb so can not delete anything.
Also try import database into new one, again without success.
Please.

 

[RoyVidar]

I have an access file that only use everyday by my sister.
Today when she tried to open the file this came 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. (Error 3197) "
I had tried to repair and compact database without success.
This file is front and back end in itself.
I use access 2003.
Please, need help.

Sometimes this message will pop up when you use bound forms, and in
addition try to change values in the reocordsource of such form,
through queries, code or other means.

If that might be the case, a "shortcut" might be to ensure the current
record is saved whenever events/code etc that does such manipulation
is called.

For some info on different save methods, take a look at the following
article by Allen Browne http://allenbrowne.com/bug-01.html, though the
main point of the article is about a bug.

BUT - 3197 can also be a symptom of memo field corruption. There is
a bit more information on Tony Toews page here
http://www.granite.ab.ca/access/corruption/symptoms.htm
search for 3197, where there are a couple of links with info. There
are more pages on the same site with lot of information about
corruption (http://www.granite.ab.ca/access/corruptmdbs.htm).