"Chas" <C***@discussions.microsoft.com> wrote in message news:1961D2EB-3DC4-45E7-8332-7DBFF147BBBB@microsoft.com...
> 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

"Joan Wild" wrote:

> 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.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Chas" <C***@discussions.microsoft.com> wrote in message news:1961D2EB-3DC4-45E7-8332-7DBFF147BBBB@microsoft.com...
> > 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
>