Can not open database (error 3197)

K

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.
 
K

kunyok

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

"gil" เขียน:
 
K

kunyok

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

"gil" เขียน:
 
G

gil

first delete the file databasename.ldb
and try

second Import your database in a new one
 
K

kunyok

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

RoyVidar

kunyok said:
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top