I NEED HELP

[Guest]

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

 

[Kevin3NF]

Access back-end or SQL Server? What version of Access? MDB or ADP?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Guest]

THANKS FOR ANSWER

ACCESS BACK END, ACCESS 2003 AND MDB

 

[Rick Brandt]

THANKS FOR ANSWER

ACCESS BACK END, ACCESS 2003 AND MDB

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

Have you tried Compact/Repair?

 

[Guest]

YES I ALREADY TRIED BUT ITS NOT WORKING IT GAVE ME THE SAME MESSAGES

 

[Kevin3NF]

Is it split into front-end/back-end with every user having their own copy of
the FE on their PC.

And please....stop typing in ALL CAPS

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Rick Brandt]

YES I ALREADY TRIED BUT ITS NOT WORKING IT GAVE ME THE SAME MESSAGES

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

 

[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

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]

 

[Guest]

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

 

[Guest]

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

 

[Guest]

i got that error message when i try to open the database.

 

[John Vinson]

i got that error message when i try to open the database.

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]

 

[Kevin3NF]

ok....if it is split into FE/BE, copy the FE to each user's machine and make
sure the tables are linked using UNC

If it is not split, split it and do the above item

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Rick Brandt]

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

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.

 

[Guest]

ok thanks a lot for your help

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]

 

[Guest]

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?

 

[John Vinson]

You sure you don't have any other solutions?

Check the list at the website posted earlier in the thread:

http://www.granite.ab.ca/access/corruptmdbs.htm

including the links to database salvage services. Threre's a chance...
maybe slim, maybe expensive, but a chance.

John W. Vinson[MVP]

 

[Guest]

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.

 

[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

 

[Guest]

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