911 Help! Error Message 3197

[Guest]

I am in desperate need of assistance! I have a 2002 DB that was intended to
be used by one person. The project for which the DB was created has been
expanding therefore I was asked to use user level security in the DB. While
I was in the process of securing the DB and importing data and objects into a
new DB I got the 3197 error message.

Apparently one of the users had seen this error before and never said
anything. Now, I can't import the table in which the corrupted record is in
(This error code only shows in one specific record)

Can anyone help me please?

 

[Joan Wild]

Apparently one of the users had seen this error before and never said
anything. Now, I can't import the table in which the corrupted record
is in (This error code only shows in one specific record)

Create a maketable query that excludes that record, and import that.
Recreate the lost record.

 

[Guest]

Joan,
Thank you very much for your assistance and I do not intend to abuse your
kindness but will the relationships of the original table carry over to the
one created through the MakeTable query?

 

[Joan Wild]

No they won't. You should be able to rename the original table, and then
name your new table to the other name.

Otherwise you can always recreate the relationships.

 

[Guest]

Hi,
I tried creating the MakeTable query but I got an error message stating,
"The microsoft Jet Database engine stopped the process because you and
another user are attempting to change the same data at the same time"
HELP Please!!!

 

[Joan Wild]

Hi,
I tried creating the MakeTable query but I got an error message
stating, "The microsoft Jet Database engine stopped the process
because you and another user are attempting to change the same data
at the same time" HELP Please!!!

Are you sure that no one else is using the database? If so, check in the
folder to see if there is a file with the same name, but an extension of
ldb. Delete that file, and reopen the mdb and try again.