Welcome to SPN

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

Sign Up Now!

Please Help -- Question about Database on a Network Drive

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

  1. Rob Hurwitz

    Rob Hurwitz
    Expand Collapse
    Guest

    I'm looking for some big-time help here...we have an Access database on
    a Network share that has about 50 users that hit it each day...some of
    these users are physically located in our office, but the majority of
    the users are at home and get to the database via Citrix or the
    company's VPN...I mention this because many times the home users
    experience problems with their Internet connection and they get kicked
    out of the VPN, and it puts the database in a state where it has to be
    repaired...

    The problem I run into is that even if I tell all of the users to exit
    the database, and they truly do, the database is still locked somehow
    by the server...I use our HelpDesk to run a program that kicks all
    users off of the file, and then I'm able to repair it...

    So with all of that said (and my apologies for the length of this
    posting) I'm wondering if anyone out there has run into this issue, and
    if so, is there anything I can do via code to disconnect all users from
    the database, essentially releasing the LDB file?

    Any help would be greatly appreciated...thanks!

    Rob Hurwitz
    rob.hurwitz@gmacm.com
     
  2. Loading...

    Similar Threads Forum Date
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Please help Questions and Answers Nov 1, 2013
    Please Help! What is the Name of the Narrator/Raagi? Gurbani Download Oct 16, 2012
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Help Please :/ Relationships Apr 19, 2011

  3. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    Hi Rob,

    > So with all of that said (and my apologies for the length of this
    > posting) I'm wondering if anyone out there has run into this issue, and
    > if so, is there anything I can do via code to disconnect all users from
    > the database, essentially releasing the LDB file?


    That's too much corruption and it's not good for the database.

    First, are you using the split Front/End-Back/End configuration? If not, you
    should.

    Second, you should put all users on a terminal server and/or citrix setup
    and avoid plain (direct) VPN connection. Access just doesnt play well with
    plain VPN connection because of its heavy bandwidth requirements. Of course
    you can combined VPN connection with Terminal Server/Citrix setup.


    HTH,
    Immanuel Sibero




    "Rob Hurwitz" <rob.hurwitz@gmacm.com> wrote in message
    news:1149191151.966784.265420@i40g2000cwc.googlegroups.com...
    > I'm looking for some big-time help here...we have an Access database on
    > a Network share that has about 50 users that hit it each day...some of
    > these users are physically located in our office, but the majority of
    > the users are at home and get to the database via Citrix or the
    > company's VPN...I mention this because many times the home users
    > experience problems with their Internet connection and they get kicked
    > out of the VPN, and it puts the database in a state where it has to be
    > repaired...
    >
    > The problem I run into is that even if I tell all of the users to exit
    > the database, and they truly do, the database is still locked somehow
    > by the server...I use our HelpDesk to run a program that kicks all
    > users off of the file, and then I'm able to repair it...
    >
    > So with all of that said (and my apologies for the length of this
    > posting) I'm wondering if anyone out there has run into this issue, and
    > if so, is there anything I can do via code to disconnect all users from
    > the database, essentially releasing the LDB file?
    >
    > Any help would be greatly appreciated...thanks!
    >
    > Rob Hurwitz
    > rob.hurwitz@gmacm.com
    >
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Those remote users should work well as long as they are using Citrix -->
    VPN->MS-ACCESS.

    when the connection is broken for a Citris user, when they re-connect, their
    screen actually re-loaded where they left off!!!

    You should not be experience ANY corruption at all.

    You need to split your database. You need to ensure that each user gets
    their OWN COPY of the mde front end.

    In the case of Citrx, that means that each user that logs on has their own
    private "space" on the server, and a copy of the mde file (so, each user
    still gets a copy of the front end, but it remains ON the citrix server).

    So, split, use a mde.

    I explain why you must split here:

    http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

    And, in the case when a user breaks the connection, you need them to re-log
    on to their citrix session, and then exit the application. So, when citrix
    breaks the connection, no damage will occur. However, if you insist on
    breaking them out of the connection, and force log them off, or using that
    utility, you most certainly will damage the ms-access file. Those users need
    to be shut down gracefully, and not blown out with a shotgun..

    I talk about using a WAN, and *WHY* corruption will occur. Read the
    following, and NOTE the part about corruption carefully:

    http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

    When you "force" a user to shut down, those "parts" of the file never make
    it back (read the above...you will understand why uses must be shutdown
    correctly).

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page