Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / July 2007

Tip: Looking for answers? Try searching our database.

I have a pretty big issue with Error code 3197: The microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
josiah.mcdonald@gmail.com - 26 Jul 2007 22:16 GMT
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 - 27 Jul 2007 12:09 GMT
>Hello,
>
[quoted text clipped - 4 lines]
>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.
>
[quoted text clipped - 14 lines]
>
>Josiah

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
josiah.mcdonald@gmail.com - 27 Jul 2007 14:45 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.