I NEED HELP

H

hjrios1969

I HAVE THIS MESSAGE: 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) WHAT I HAVE TO DO TO RESOLVE IT?
THANKS
 
R

Rick Brandt

hjrios1969 said:
THANKS FOR ANSWER

ACCESS BACK END, ACCESS 2003 AND MDB
Click to expand...

I have seen that with corrupted tables (usually a memo field).

Have you tried Compact/Repair?
 
R

Rick Brandt

hjrios1969 said:
YES I ALREADY TRIED BUT ITS NOT WORKING IT GAVE ME THE SAME MESSAGES
Click to expand...

Do you mean you got the same message *during* the Compact/Repair or that the
Compact/Repair completed ok, but made no difference?
 
J

John Vinson

I HAVE THIS MESSAGE: 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) WHAT I HAVE TO DO TO RESOLVE IT?
THANKS
Click to expand...

One way I've seen this error is if you're trying to edit data in a
table in VBA code, and the same record is already open on a Form.
What's the context? Under what circumstances does this error arise?
Could you post your code, if there is any code?

John W. Vinson[MVP]
 
H

hjrios1969

sorry for the all caps lol
the program is save in a main server and each of us has access to it
 
H

hjrios1969

when i click the compact and repair function i got the same error message
(error 3197)
 
J

John Vinson

i got that error message when i try to open the database.
Click to expand...
Then your database is either corrupted, or you have some code in the
Autoexec macro or the automatically opened form. Do you get the error
if you hold down the Shift key while opening the database?

I'd suggest creating a new, empty database and using File... Get
External Data... Import to import whatever can be salvaged from this
database. That... or get out your backup disks.

John W. Vinson[MVP]
 
R

Rick Brandt

hjrios1969 said:
when i click the compact and repair function i got the same error
message (error 3197)
Click to expand...

Then you have a corrupted table. Try importing the tables one at a time
into a new blank file. The corrupted one(s) will fail during the import.
If you are lucky it will only be one table. If it is a table with a memo
field you can scroll through the table directly and eventually you will see
one that has #ERROR in the memo field. You will need to delete that record
and then try the Compact/Repair again.
 
H

hjrios1969

ok thanks a lot for your help

John Vinson said:
Then your database is either corrupted, or you have some code in the
Autoexec macro or the automatically opened form. Do you get the error
if you hold down the Shift key while opening the database?

I'd suggest creating a new, empty database and using File... Get
External Data... Import to import whatever can be salvaged from this
database. That... or get out your backup disks.

John W. Vinson[MVP]
Click to expand...
 
2

2.0 to 2000 converter - Bruce

:) You guys have given a lot of answers here, but if hjrios's db is
anything like the one I was sent to see if I could repair it, then the only
solution is "get out your backup disks". The error message comes up as soon
as you go to open the db. It also comes up when you try to Compact & Repair,
when you hold down the Shift key, and when you go to try and Import into
another blank db. I'm going to reply to the person who sent this one, and
tell them to treat it like the db has been deleted. It's as good as.

You sure you don't have any other solutions?
 
I

idribble

I had this same problem and before posting the problem found this post which
I was able to find the #ERROR (which was stuck out) in one of my tables for
the memo field which solved my problem. Hope is solves yours.
 
A

Allen Browne

This is possible in Access 2007 only.

The new version allows you to set the Text Format property of the Memo field
in your table to Rich Text. Then when you type or paste the link in, it will
rerecognise it as a hyperlink, and make it clickable.

Previous versions do not support HTML within memo fields, and cannot format
part of a field as a hyperlink.

If you are interested in the state of the new version, see:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html
 
F

Fernando Oliveira

I read this topic and I have a similar problem.
The diference being that I am using SQL 2005 Server and the table is linked
by ODBC to an Access 207 MDB.
If I open the Access database and the attached table, I can delete records
without any problem. However, if I add any recor or edit any record, I cannot
edit or delete records without getting the 3197 error. Any Ideas on this?
Thank you
Fernando
 

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

Similar Threads

Corrupt db 3
Database Become Inaccessible 2
The Microsoft Jet Engine Stopped the process 1
can't open ACCESS2003 database due to error 3197 2
database wont open 7
Database Locked up 1
Can not open database (error 3197) 6
An error 3197 tells me I have to execute the update method again? 0

Top