By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

Annoying Locked Record

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.