how to gracefully close an access db on a shared folder

Discussion in 'Windows Server' started by OM, Oct 2, 2007.

  1. OM

    OM Guest

    Hi,

    I have an access database that is shared by the network users. These
    users tend to forget to close the applications when they finish their
    work at the end of the day. This makes the server unable to backup the
    file (being open). Can someone advice me how to gracefully close the
    file when all users are longer using the db (even though their
    application might still be open)?

    Thanks
     
    OM, Oct 2, 2007
    #1
    1. Advertisements

  2. Hello,

    gracefully doesn't mean respecting the application logic. This application
    may does things when closing up (like freeing opened business case...) that
    can't be played.

    You can use net session /delete /yes
    or net file XX /close but you need a way to find the id.

    It's much better to logoff users on workstations before starting backup, so
    you also backup roaming profile and prevent unconsistent application
    behaviour the next morning.
     
    Mathieu CHATEAU, Oct 2, 2007
    #2
    1. Advertisements

  3. OM

    Alang Guest

    I can't tell you how to close off the user end but I have used an
    access 2000 DB for the past few years and backed it up nightly with no
    problems.

    Make sure your DB is split into a backend and frontends. Locate the
    copies of the frontends on the client computers with a link to the
    tables on the backend on the server. Even if the client is logged on
    you can still make a copy of the backend tables. We don't run ours off
    the domain server. We use an old win98 file server and a free utility
    called taskzip that can run timed backups. In 9 years of running an
    access db this way we have rarely had any problems with backups.

    You may get a better answer on the Access newsgroups
     
    Alang, Oct 3, 2007
    #3
  4. OM

    OM Guest

    Thanks for the input
     
    OM, Oct 3, 2007
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.