Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Sydney - Australia
    Posts
    2

    Unanswered: MSAccess Hangs when one user Shuts down PC

    Hi all, Hope you may be able to help us here. We have an Access database that runs on our file server and is shared by about 3 users.

    They can open and close the database fine throughout the day however when one of the users shuts down his PC at night the other user loses his database connection and has to reboot his PC to be able to open the database again. Simply trying to re-open without a restart does not work

    Its always the same user when he shuts down causes the other to be kicked off as well. It Only happens when his PC is shutdown (After closing access) and doesnt happen if Access is shut down and the PC keeps running.

    We are running XP Pro on both machines, and the problem only seems to have appeared since we upgraded the Database from Office 97.

    Also the Database is in Access 2000 format (Not 2002) Not sure if this may be an issue either

    Any ideas or where to look first greatly appreciated

  2. #2
    Join Date
    Dec 2002
    Posts
    117

    Possible?

    Is it possible that the PC you are shutting down is the file server?

  3. #3
    Join Date
    Feb 2004
    Location
    Sydney - Australia
    Posts
    2

    Wink Re: Possible?

    Originally posted by jmonroe
    Is it possible that the PC you are shutting down is the file server?
    I wish it was that simple :-)

    Afraid not It is a shared Access file that resides on the server and is accessed by users from their workstations

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 8

    Try this

    Spit the database

    into

    data

    Screens/everything else

    Know put Screens/everything on the Work stations

    and the data on the server

    That should fix every thing
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •