locked LDB FILE

  • Thread starter Captain Kangaroo
  • Start date
C

Captain Kangaroo

When exiting my MsAccess database I've noticed that the LDB File doesn't go
away as it should.

when I tried to delete the ldb file ( I'm the only one using it ) it says
record locked.

I tried rebooting - No Dice.


I'm at my wits end trying to figure this out
 
K

KARL DEWEY

Backup your database. Then do a Compact and Repair.
If it still does not go away then ask you LAN man to delete.
 
J

Jerry Whittle

All users of the database, including yourself, must have at least read,
write, and create and delete privileges to the folder holding the database
file. Not just the database .mdb file, but the entire folder.
 
C

Captain Kangaroo

Have already confirmed that access to the file is established.
this wasn't occuring yesterday.

I have copied the mdb file to the local drive as a test and when the ldb
file appears I would close the file,
but the ldb does not go away. Even when deleting the file on the local
drive - remember there's no permissions here
because I'm the owner of the file.

I'm afraid the only alternative is to reboot the server - last resort
 
T

Tony Toews [MVP]

Captain Kangaroo said:
Have already confirmed that access to the file is established.
this wasn't occuring yesterday.

I have copied the mdb file to the local drive as a test and when the ldb
file appears I would close the file,
but the ldb does not go away. Even when deleting the file on the local
drive - remember there's no permissions here
because I'm the owner of the file.

Yes, but what are the permissions on the folder not the file? The
ldb file is inheriting permissions from the folder and not the MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
J

Jasmine

I have System Administrator Rights , which is Full Control -
Read,Write,Execute,Delete
 
S

Steven Chicago,Illinois

Dear Captain Kangaroo,

Did you figure it out?

Please post the answer for the rest of us who will be following you across
this bridge and searching here in the discussion group to learn what we
should do.

Thanks and Good Luck,
Steve
 
M

Mary

If you haven't already done so, you could try opening the ldb file to see who
it shows as being logged in.
 
T

Trepalium

Is this DB on a local drive or a share drive on a network?

If you have administrative rights on the machine your DB is stored on
you can do the following:


1.) Open Control Panel
2.) Select Administrative Tools
3.) Select Computer Management
4.) Select Shared Folders
5.) Select Open Files
6.) If your .ldb is there right click and select close files


If your .ldb is being shared somehow this is the best way to get rid
of it. I've had to have my Sys Admins do this a couple times to
unlock .mdbs on our file servers.


Hope this helps a little.

Thanks,
Trep.
 
R

rtviper

I have periodically had the same problem. Using Task Manager, I find the
process, Stop it and then delete the .LDB file.
 
P

Pieter Wijnen

Traditionally linked to Recordsets not beeing Closed

ie Set Rs = Db.OpenRecordset("MySet")
......
Rs.Close : Set rs = Nothing ' Excplicit housecleaning

Pieter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top