Re: Error 3197

On Wed, 2 May 2007 03:19:01 -0700, Foo.sg <Foosg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

When I try to open one of my BE mdb I get the 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)". This
happended after some fault in the connection between the FE and BE and the
error happend even after I copied the BE from the server to a standalone PC.

First, make a copy of the problem database. If you've already tried to open the database, you may have a leftover
lockfile (.ldb file). Check the directory with the database and delete any .ldb files you see.

Can you actually open the backend? If so, then have you tried Compact & Repair form the Access menu? Open Access, open
the database, then click Tools - Database Utilities

JetComp sometimes works when C&R doesn't: http://support.microsoft.com/kb/273956

Can you import to a new, blank database?

Finally, if none of these work, it might be time to restore from a recent backup (and recreate the data that's missing)
or contact a repair service. There are several out there; www.pksolutions.com seem to be often recommended, but I've
never had need of their services (thankfully).

Tony Toews has a great page on this: http://www.granite.ab.ca/access/corruption/retrievedata.htm


Can anyone please help how I can recover my mdb?

Thanks

Scott McDaniel
scott@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • Re: DB LOCKS
    ... The growth process expanded the size of the database, ... happend again by expanding the size of the database in EM (in the ... In our case, the number was off by 10%, which was the auto ...
    (microsoft.public.sqlserver.server)
  • Re: Brief "dropping" and re-establishing of network connection
    ... Hey there all I just happend to be looking to post another problem and I ... stating the connection to the database was lost and data lass could result. ... database after the dis-connection. ...
    (microsoft.public.windows.server.sbs)
  • Re: help, my accessxp-db certenly become "compressed"
    ... One of Access's shortcomings (actually Jet's, which is Access's database ... actually it is Compact and Repair, it recovers unused space and repairs ... > While working with my AccessXP-db, just tasting in new records, something happend ...
    (microsoft.public.access.gettingstarted)
  • RE: Who deleted my records?
    ... Enable C2 audit, you will be able to tell who did what when and etc....from ... What happend in the past, you might not be able to find out who did it. ... > access to this database for reading/writing. ...
    (microsoft.public.sqlserver.security)
  • Re: MA Access 97 File menu missing HELP PLEASE!!!!
    ... Do the users who don't see File when the database is open see it when they ... the user who can't see File open Access and then open the database while ... have read about this and checked the references and one of the users ... Microsoft Access 8.0 Object Library ...
    (microsoft.public.access.forms)