By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Locked table, err 3197

P: n/a
I have an Access 2000 database I use together with one other person.
As I try to append new records to a table using a standard jet SQL
INSERT INTO statement I get error 3197, another user is trying to
change the same data at the same time as I am. This is not true, she
is not here today. I fear my table (maybe my database) is corrupted
(appending to a copy of the table does not work, nor does appending to
a newly built copy of the table with empty fields).

Any ideas on the root cause of the problem? Any suggestions on how to
release the lock and free the table to insert new records?

thanks
JH Higgins
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Jo************@Hitchcock.org (JH Higgins) wrote:
I have an Access 2000 database I use together with one other person.
As I try to append new records to a table using a standard jet SQL
INSERT INTO statement I get error 3197, another user is trying to
change the same data at the same time as I am. This is not true, she
is not here today. I fear my table (maybe my database) is corrupted
(appending to a copy of the table does not work, nor does appending to
a newly built copy of the table with empty fields).


See the Access Corruptions FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

P: n/a
Tony Toews <tt****@telusplanet.net> wrote in message news:<4f********************************@4ax.com>. ..
Jo************@Hitchcock.org (JH Higgins) wrote:
I have an Access 2000 database I use together with one other person.
As I try to append new records to a table using a standard jet SQL
INSERT INTO statement I get error 3197, another user is trying to
change the same data at the same time as I am. This is not true, she
is not here today. I fear my table (maybe my database) is corrupted
(appending to a copy of the table does not work, nor does appending to
a newly built copy of the table with empty fields).


See the Access Corruptions FAQ at my website.

Tony


Got it, and thanks Tony, got your website bookmarked. Yes indeed I
have memmo fields with junk data in them. I guess I have to look into
tuneing up my recordset locks.
jhh
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.