Article View: comp.databases.ms-access
Article #362Re: Record Locking problem in table
From: Nick Farrell
Date: Wed, 24 Feb 1999 00:00
Date: Wed, 24 Feb 1999 00:00
30 lines
1860 bytes
1860 bytes
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:
<7b0usl$c7o$1@bignews.shef.ac.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7b0gpb$4qc$1@bignews.shef.ac.uk> <7b0udt$kuv$1@usenet46.supernews.com>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: 1143dd,c34d39e6dedbcf54 X-Google-Attributes: gid1143dd,public X-Google-Thread: 102b1d,c34d39e6dedbcf54 X-Google-Attributes: gid102b1d,public From: "Nick Farrell" <nickfarrell@dial.pipex.com> Subject: Re: Record Locking problem in table Date: 1999/02/24 Message-ID: <7b0usl$c7o$1@bignews.shef.ac.uk> X-Deja-AN: 447881890 References: <7b0gpb$4qc$1@bignews.shef.ac.uk> <7b0udt$kuv$1@usenet46.supernews.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: University of Sheffield, UK Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.chat,microsoft.public.access.forms