DB locked "File Already In Use" NO .LDB FILE!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chas - 10 Sep 2007 20:28 GMT

Help!
Okay I know there will be flack for this but here it goes.
This morning I am in the midst of converting an Access 97 Backend to an
Access 2003 Backend. Which had been scheduled for some time.
During the process I changed security permissions on a Win2003 Server so
that only "Admin" had any privledges on the DB file.
Of course... I was told that they wanted to wait until Wednesday before
converting the backend. When I restored the file permissions to include those
users that had permissions before they were not able to get back in to the
database. The error message stated that the file is already in use. The funny
thing (acutally not so funny) is that I can not find the .ldb file.

Is there anyway to gain access to the DB?? Also ideas without a reboot of
the server would be greatly appreciated!

And before you ask YES I have also tried restoring from backup with no luck.

Thanks in advance,
CB

Reply to this Message

Joan Wild - 11 Sep 2007 16:46 GMT

Did you restore permissions on both the mdb file, or on the folder (it's the folder they need the permissions on). Then compact the mdb - the resulting file will inherit permissions from the folder.

Signature

Joan Wild
Microsoft Access MVP

> Help!
> Okay I know there will be flack for this but here it goes.
[quoted text clipped - 15 lines]
> Thanks in advance,
> CB

Reply to this Message

Chas - 11 Sep 2007 17:40 GMT

Yes,
This problem was resolved by going in to the computer management tool
looking for open shares and disconnecting the user that had it open. After I
did this the db was open for all again!

> Did you restore permissions on both the mdb file, or on the folder (it's the folder they need the permissions on). Then compact the mdb - the resulting file will inherit permissions from the folder.
>
[quoted text clipped - 17 lines]
> > Thanks in advance,
> > CB

Reply to this Message