locked LDB FILE

[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

 

[Guest]

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

 

[Guest]

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.

 

[Captain Kangaroo]

Have already done that - incidentally - I am the LAN man

 

[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

 

[Alex Dybenko]

Hi,
looks like your mdb is still open, either by other user, you by yourself -
sometimes access does not quit, still running and not visible. check task
manager for running msaccess.exe process

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Tony Toews [MVP]]

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/

 

[Jasmine]

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

 

[Guest]

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

 

[Guest]

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

 

[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.

 

[Guest]

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

 

[Pieter Wijnen]

Traditionally linked to Recordsets not beeing Closed

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

Pieter