469,926 Members | 1,541 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

Annoying Locked Record

Hi

Ive got an Access97 db with a record in one of the tables that appears
to be locked by another user even though no one is using it and the
..ldb confirms this. I need to delete this record but cant!!! Can
anyone tell me how I can do this?

Thanks
Nov 12 '05 #1
1 3138
On 17 Sep 2003 02:41:44 -0700 in comp.databases.ms-access,
du****@joseph96.freeserve.co.uk (Dudley Joseph) wrote:
Hi

Ive got an Access97 db with a record in one of the tables that appears
to be locked by another user even though no one is using it and the
.ldb confirms this. I need to delete this record but cant!!! Can
anyone tell me how I can do this?


Probably corrupt.

Try:
Compact database
if no joy:
backup database and repair
if still no joy:
(this is a long one)

Create new database
Import everything except that table from old database
Import that table but with no data
link that table (it'll have a 1 on the end as the name would have been
duplicated, don't worry)
create a query on that table
add all fields - not * but double click table header so all fields are
highlighted and drag them down to the grid.
put in some criteria that will filter out that 1 dodgy record.
turn the query into an append query and append to the empty table.
run query.
delete the linked table.
voilla.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by David C. Barber | last post: by
2 posts views Thread by Anastassios Giannaras | last post: by
6 posts views Thread by DebbieG | last post: by
reply views Thread by Access Programming only with macros, no code | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.