state of admin

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emma Hope - 10 Oct 2004 21:54 GMT

I am the administrator of a secured multiuser db, i have
connected via remote access to make changes, the remote
access has kicked me out leaving the database stuck in a
state of admin by myself, i cant get my connection
disconnected and the db won't let me in, is there any way
i can force it to kick me out so everyone can use it (and
i can continue making my changes)

Thanks
Emma

Reply to this Message

Larry Linson - 11 Oct 2004 02:48 GMT

> I am the administrator of a secured multiuser db, i have
> connected via remote access to make changes, the remote
[quoted text clipped - 3 lines]
> i can force it to kick me out so everyone can use it (and
> i can continue making my changes)

Yes, if you can delete the LDB file, I think you'll be in good shape...
CAUTION: do not delete the MDW file, or you'll create more problems than you
solve. Now, even if the LDB file is shown in use, I think it can still be
deleted. You may need to contact your network/systems administrator for
assistance, if that's the case.

If you can't, then all I can advise is to go to your most recent backup
copy. If there is no "most recent" backup copy, all I can advise is that
there be one for every important database, either in production or in
development.

Larry Linson
Microsoft Access MVP

Reply to this Message

Brendan Reynolds - 11 Oct 2004 13:42 GMT

Piggy-backing on your post, Larry, because I don't see earlier posts in this
thread ...

If Emma can not delete the ldb file via Windows, she may be able to do so
from a command prompt (DOS window).

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

>> I am the administrator of a secured multiuser db, i have
>> connected via remote access to make changes, the remote
[quoted text clipped - 18 lines]
> Larry Linson
> Microsoft Access MVP

Reply to this Message

Emma Hope - 26 Oct 2004 21:29 GMT

Hi Brndan,

Thanks for the reply, however when i try to delete the .ldb through the
command prompt, i am told it cannot be deleted as it is in use. any ideas?

Thanks
Emma

> Piggy-backing on your post, Larry, because I don't see earlier posts in this
> thread ...
[quoted text clipped - 24 lines]
> > Larry Linson
> > Microsoft Access MVP

Reply to this Message

Brendan Reynolds - 27 Oct 2004 11:33 GMT

Then you need to reboot the PC.

Signature

> Hi Brndan,
>
[quoted text clipped - 36 lines]
>> > Larry Linson
>> > Microsoft Access MVP

Reply to this Message

Emma Hope - 31 Oct 2004 15:50 GMT

Obviously rebooting my PC to help delete a lock file that is there because a
networked user on a multiuser database using the db is not going to help.

Does anyone else have an advice. Thanks.

> Then you need to reboot the PC.
>
[quoted text clipped - 38 lines]
> >> > Larry Linson
> >> > Microsoft Access MVP

Reply to this Message

Emma Hope - 26 Oct 2004 21:29 GMT

Brendan.

Thanks for the info but when attempting to delete using the command prompt,
i am told the file cannot be deleted because it is in use, any ideas?

Thanks
Emma

> Piggy-backing on your post, Larry, because I don't see earlier posts in this
> thread ...
[quoted text clipped - 24 lines]
> > Larry Linson
> > Microsoft Access MVP

Reply to this Message