Article View: comp.databases.ms-access
Article #363Re: Record Locking problem in table
From: Pete B
Date: Wed, 24 Feb 1999 00:00
Date: Wed, 24 Feb 1999 00:00
42 lines
2256 bytes
2256 bytes
Only other common thing I can think of is the workgroup library, but that should not be causing locks. -- Pete B Nick Farrell wrote in message <7b0usl$c7o$1@bignews.shef.ac.uk>... >Yep, tried both of those and neither of those worked!!! > >It's a hell of a problem... > >At the moment I've created a new table with the same structure, copied and >pasted all the records in, created a new index, and then I'm having to go >through every table related to the index and change the index to the newly >created one........ it's so amusing, I've got 5 machines working on >re-indexing it at the moment!!! > >There must be some sort of command to release all of the locks on >records......? > >Cheers, > >Nick Farrell > > >Pete B wrote in message <7b0udt$kuv$1@usenet46.supernews.com>... >>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 >> > > >
Technical Details
Message-ID:
<7b1581$op2$1@usenet42.supernews.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7b0gpb$4qc$1@bignews.shef.ac.uk> <7b0udt$kuv$1@usenet46.supernews.com> <7b0usl$c7o$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: 1143dd,c34d39e6dedbcf54 X-Google-Attributes: gid1143dd,public X-Google-Thread: 102b1d,c34d39e6dedbcf54 X-Google-Attributes: gid102b1d,public X-Google-Thread: ff0ac,c34d39e6dedbcf54 X-Google-Attributes: gidff0ac,public From: "Pete B" <barnesp@datatek.com> Subject: Re: Record Locking problem in table Date: 1999/02/24 Message-ID: <7b1581$op2$1@usenet42.supernews.com> X-Deja-AN: 447921830 References: <7b0gpb$4qc$1@bignews.shef.ac.uk> <7b0udt$kuv$1@usenet46.supernews.com> <7b0usl$c7o$1@bignews.shef.ac.uk> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Complaints-To: newsabuse@remarQ.com X-Trace: 919869505 GCRUXKJXP45FED08B usenet42.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