Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Close an ldb file

Discussion in 'Information Technology' started by Rob M, Jul 28, 2006.

Tags:
  1. Rob M

    Rob M
    Expand Collapse
    Guest

    I have multiple users using an Access 2003 database application from a shared
    drive. At any point in time I am able to identify the names of the machines
    that are logged on. However, there is one machine that ALWAYS shows up as
    logged on, even when it isn't. Does anyone know how I can close the ldb file
    so that I can get on with maintaining the application? Or kick off the user
    who isn't really on?
     
  2. Loading...

    Similar Threads Forum Date
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014
    India After Badrinath, Kedarnath now Sikh shrine Hemkunt Sahib closed temporarily Breaking News Jun 28, 2013
    Grammer / Vyakarn Fateh multimedia forced to close for lack of funds Language, Arts & Culture Nov 21, 2012
    General The Closer Videos Jul 26, 2012
    Close Brush with the Law, a Personal Story Business, Lifestyle & Leisure Sep 24, 2011

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Rob M wrote:
    > I have multiple users using an Access 2003 database application from
    > a shared drive. At any point in time I am able to identify the names
    > of the machines that are logged on. However, there is one machine
    > that ALWAYS shows up as logged on, even when it isn't. Does anyone
    > know how I can close the ldb file so that I can get on with
    > maintaining the application? Or kick off the user who isn't really on?


    Sounds like whoever uses that one machine does not have full rights (no
    delete rights) to the directory where the file is located, or they have a
    habit of just turning their machine off with Access, and likely other
    programs still running.

    Once you get them off line, you can just delete the file.

    --
    Joseph Meehan

    Dia duit
     
  4. Rob M

    Rob M
    Expand Collapse
    Guest

    I wish it were so. I know the problem machine, and I know that the machine
    is NOT using the application. Nevertheless, I cannot delete the ldb file.

    "Joseph Meehan" wrote:

    > Rob M wrote:
    > > I have multiple users using an Access 2003 database application from
    > > a shared drive. At any point in time I am able to identify the names
    > > of the machines that are logged on. However, there is one machine
    > > that ALWAYS shows up as logged on, even when it isn't. Does anyone
    > > know how I can close the ldb file so that I can get on with
    > > maintaining the application? Or kick off the user who isn't really on?

    >
    > Sounds like whoever uses that one machine does not have full rights (no
    > delete rights) to the directory where the file is located, or they have a
    > habit of just turning their machine off with Access, and likely other
    > programs still running.
    >
    > Once you get them off line, you can just delete the file.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Rob M wrote:
    > I wish it were so. I know the problem machine, and I know that the
    > machine is NOT using the application. Nevertheless, I cannot delete
    > the ldb file.
    >
    > "Joseph Meehan" wrote:
    >
    >> Rob M wrote:
    >>> I have multiple users using an Access 2003 database application from
    >>> a shared drive. At any point in time I am able to identify the
    >>> names of the machines that are logged on. However, there is one
    >>> machine that ALWAYS shows up as logged on, even when it isn't.
    >>> Does anyone know how I can close the ldb file so that I can get on
    >>> with maintaining the application? Or kick off the user who isn't
    >>> really on?

    >>
    >> Sounds like whoever uses that one machine does not have full
    >> rights (no delete rights) to the directory where the file is
    >> located, or they have a habit of just turning their machine off with
    >> Access, and likely other programs still running.
    >>
    >> Once you get them off line, you can just delete the file.
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit



    Assuming the file is on a server, have one of the techs delete the file,
    it may be corrupted. Maybe even better would be to rename the file.



    --
    Joseph Meehan

    Dia duit
     
  6. Rob M

    Rob M
    Expand Collapse
    Guest

    I have tried renaming - it won't let me. Is there something that the techs
    can do that I cannot do?

    "Joseph Meehan" wrote:

    > Rob M wrote:
    > > I wish it were so. I know the problem machine, and I know that the
    > > machine is NOT using the application. Nevertheless, I cannot delete
    > > the ldb file.
    > >
    > > "Joseph Meehan" wrote:
    > >
    > >> Rob M wrote:
    > >>> I have multiple users using an Access 2003 database application from
    > >>> a shared drive. At any point in time I am able to identify the
    > >>> names of the machines that are logged on. However, there is one
    > >>> machine that ALWAYS shows up as logged on, even when it isn't.
    > >>> Does anyone know how I can close the ldb file so that I can get on
    > >>> with maintaining the application? Or kick off the user who isn't
    > >>> really on?
    > >>
    > >> Sounds like whoever uses that one machine does not have full
    > >> rights (no delete rights) to the directory where the file is
    > >> located, or they have a habit of just turning their machine off with
    > >> Access, and likely other programs still running.
    > >>
    > >> Once you get them off line, you can just delete the file.
    > >>
    > >> --
    > >> Joseph Meehan
    > >>
    > >> Dia duit

    >
    >
    > Assuming the file is on a server, have one of the techs delete the file,
    > it may be corrupted. Maybe even better would be to rename the file.
    >
    >
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  7. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 24 Jul 2006 19:00:02 -0700, Rob M
    <RobM@discussions.microsoft.com> wrote:

    >I have tried renaming - it won't let me. Is there something that the techs
    >can do that I cannot do?


    Reboot the server... or (less drastic) override the lock on the file.

    John W. Vinson[MVP]
     

Share This Page