MS Access Multiuser - .ldb file goes missing

Author

.ldb file goes missing

KurtW

2005-09-06, 8:25 pm

Hi all:

We have an Access app that lives on a shared network drive. On two occasions
in the last few months we have had instances where the users are suddenly
locked out. They will get a 'database already in use' message and be denied
access, even though they are legit users who are in the approved group.

I have been banging my brains out over this – everything looks right. But a
senior developer suggested that a .ldb file had been corrupted. We restored
the last known .ldb from network backup and the problem is fixed!

So, my question is this: WHY would an .ldb file suddenly go away? The users
do not have the knowledge to delete it. Our network guys swear they don't
touch it and I never went near it. Has anyone ever seen this before?

Thanks

Kurt

Larry Linson

2005-09-07, 3:26 am

LDB files are _supposed_ to go away when the last user logs out of the
database with which they are associated. If there are any users in the
database, they are open, and it should be impossible to delete them -- well,
only someone with adminstrative authority can delete an open file, if I
understand correctly.

Assuming that your system adminstrators do not go around deleting files on a
whim, I'd have to think there is something corrupted or in error either in
Access or elsewhere in that system that is deleting it.

Larry Linson
Microsoft Access MVP

"KurtW" <KurtW@discussions.microsoft.com> wrote in message
news:A282D1DD-5E3E-4AB3-A8A0- 4D2699EDE70A@microso
ft.com...
> Hi all:
>
> We have an Access app that lives on a shared network drive. On two
> occasions
> in the last few months we have had instances where the users are suddenly
> locked out. They will get a 'database already in use' message and be
> denied
> access, even though they are legit users who are in the approved group.
>
> I have been banging my brains out over this - everything looks right. But
> a
> senior developer suggested that a .ldb file had been corrupted. We
> restored
> the last known .ldb from network backup and the problem is fixed!
>
> So, my question is this: WHY would an .ldb file suddenly go away? The
> users
> do not have the knowledge to delete it. Our network guys swear they don't
> touch it and I never went near it. Has anyone ever seen this before?
>
> Thanks
>
> Kurt
>

KurtW

2005-09-07, 9:24 am

Thanks Larry:

That is also what we believe. We are just going to have to monitor things
and see.

Kurt

"Larry Linson" wrote:

> LDB files are _supposed_ to go away when the last user logs out of the
> database with which they are associated. If there are any users in the
> database, they are open, and it should be impossible to delete them -- well,
> only someone with adminstrative authority can delete an open file, if I
> understand correctly.
>
> Assuming that your system adminstrators do not go around deleting files on a
> whim, I'd have to think there is something corrupted or in error either in
> Access or elsewhere in that system that is deleting it.
>
> Larry Linson
> Microsoft Access MVP
>
>
> "KurtW" <KurtW@discussions.microsoft.com> wrote in message
> news:A282D1DD-5E3E-4AB3-A8A0- 4D2699EDE70A@microso
ft.com...
>
>
>

Sponsored Links