Re: Record Locking problem in table

Article View: comp.databases.ms-access

Article #361

Back to comp.databases.ms-access Previous Next

#361

From: Pete B
Date: Wed, 24 Feb 1999 00:00

34 lines
2109 bytes

Try deleting the locking data *.LDB file associated with the data mdb.
Access will create a new one if it is not found.

If that does not do it, try importing all of the objects into a new mdb (NOT
exporting to a new mdb from the problem mdb; import, not export!).

--

Pete B


Nick Farrell wrote in message <7b0gpb$4qc$1@bignews.shef.ac.uk>...
>HELP!!!!!
>
>I have a table, which is worked on in a multi-user environment. However,
>something's gone wrong somewhere, and a number of records have become
>locked - even though no-one has them open. Repairing the database doesn't
>solve the problem, and compacting it brings up errors saying that someone
>else is using the records.
>
>I've tried exporting the table to another file, and then reimporting it - I
>can't do that, since 'someone else' is using it.
>
>Is there any way anyone can think of to solve the problem - is there
>something which will reset all the record locks on a table??
>
>Please help me!
>
>Cheers,
>
>Nick Farrell
>nickfarrell@dial.pipex.com
>
>

Technical Details

Message-ID: <7b0udt$kuv$1@usenet46.supernews.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7b0gpb$4qc$1@bignews.shef.ac.uk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,c34d39e6dedbcf54
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,c34d39e6dedbcf54
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,c34d39e6dedbcf54
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,c34d39e6dedbcf54
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 1143dd,c34d39e6dedbcf54
X-Google-Attributes: gid1143dd,public
From: "Pete B" <barnesp@datatek.com>
Subject: Re: Record Locking problem in table
Date: 1999/02/24
Message-ID: <7b0udt$kuv$1@usenet46.supernews.com>
X-Deja-AN: 447881887
References: <7b0gpb$4qc$1@bignews.shef.ac.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: newsabuse@remarQ.com
X-Trace: 919862525 GCRUXKJXP45FED08B usenet46.supernews.com
Organization: Posted via RemarQ, http://www.remarQ.com - Discussions start here!
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.chat,microsoft.public.access.forms

Reply to Parent Message