I have a pretty big issue with Error code 3197: The microsoft Jet Database Engine stopped the proces

[josiah.mcdonald]

Hello,

I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".

This isn't true because I have it on my local computer.

I've tried importing to a new DB file and I get the same error.

I've been reading through other forum posts and tried JetComp.exe and
that also gave me an error.

Also I've read that since the users can use the file normally its
probably an issue with one or more of the system tables. However no
one has addressed how to solve this case.

Can someone please help me as soon as possible as this DB file
contains very important information and if fails will cause the group
to be "Dead in the water"

Thanks in advance,

Josiah

 

[Scott McDaniel]

Hello,

I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".

So you've imported everything to a new container? If so, then perhaps you have a stray lock file hanging around. With
the database closed, examine the folder hosting the backend ... delete any file that ends in .ldb, then restart Access.
These are lockfiles created and destroyed by Access, and sometimes Access fails to kill one on exit.

This isn't true because I have it on my local computer.

I've tried importing to a new DB file and I get the same error.

I've been reading through other forum posts and tried JetComp.exe and
that also gave me an error.

Also I've read that since the users can use the file normally its
probably an issue with one or more of the system tables. However no
one has addressed how to solve this case.

Can someone please help me as soon as possible as this DB file
contains very important information and if fails will cause the group
to be "Dead in the water"

Thanks in advance,

Josiah

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[josiah.mcdonald]

Scott

Not exactly I tried to import the tables to a new database and
received the same error. I cannot open the file at all.