Re: Current users in database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: MacDermott (macdermott_at_NoSpam.com)
Date: 09/05/04 

Date: Sun, 5 Sep 2004 19:45:56 -0400

What version of Access are you using?
What sort of action are you contemplating to log users out?
    Simply disconnecting them could easily lead to database corruption.

I've seen a neat little programming trick where the database is programmed
to check a separate file on start-up. The DBA can alter that file to either
permit or prohibit further logons.

HTH
    - Turtle

"Terry" <Terry@discussions.microsoft.com> wrote in message
news:F606202A-C602-4B55-B6A2-042807F57368@microsoft.com...
> It does not provide enough information. I would like to report the name &
> computer of the logged on database user so action can be taken to log the
> users out. I believe it is also possible to lock the database from
additional
> users.
>
> "MacDermott" wrote:
>
> > How about checking for the existence of an LDB file?
> > Of course this won't exist if someone else has the database opened
> > exclusively, but then you'd get a trappable error, wouldn't you?
> >
> > - Turtle
> >
> > "Terry" <Terry@discussions.microsoft.com> wrote in message
> > news:6FB6C93B-D030-4350-9632-FF4A956C9514@microsoft.com...
> > > If this is not the correct forum please advise.
> > > I want to check whether it is possible to open a database exclusively
by
> > > checking which users currently have the database open. There appears
to be
> > > some code for A97 using MSLDBUSR.DLL but this DLL does not appear to
> > register
> > > under Windows XP.
> > > Another solution checks the current users for the current database
using
> > the
> > > GUID but I want to check another, user selected, database.
> > > Can anyone put me on track for a solution to this problem please?
> > > Terry
> >
> >
> >

Relevant Pages

  • Re: Current users in database
    ... > database prohibiting additional users logging on. ... >> What sort of action are you contemplating to log users out? ... >> I've seen a neat little programming trick where the database is ... >> HTH ...
    (microsoft.public.access.formscoding)
  • Re: Terminating User Sessions
    ... You cannot forcefully log users out of the VSS because each user acceses ... directly the database. ... - lock the VSS database to prevent new users from loging in ... logs in in a TS session and accesses the database locally. ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: MS 2000 Secured Database
    ... Total agreement about the splitting (I use a log-in db app to check for ... a new version / download and log users in... ... lock file - this is a file placed in the directory that the database is ...
    (comp.databases.ms-access)
  • Re: Exchange Error & Backup Errors Related?
    ... Looks like EventID 35 was due to low disk space. ... database corruption or even a problem with Exchange 2003 SP2. ... Information Store' returned 'Error returned from an ESE function call. ... Information Store First Storage Group: The database page read from ...
    (microsoft.public.windows.server.sbs)
  • Re: Growing Exchange store problem
    ... I think I have ruled out database corruption. ... We created a new mailbox store ... >>>runs as a service and uses ExOleDB to pull data from the Exchange store. ...
    (microsoft.public.exchange.admin)