Annoying Locked Record

[Dudley Joseph]

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

[Trevor Best]

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.