Windows Out of MS-DOS File Handles

Discussion in 'Software' started by Arthur2Sheds, 25 Sep 2003.

  1. Arthur2Sheds

    Arthur2Sheds Jackson

    Joined:
    19 May 2003
    Posts:
    817
    Likes Received:
    1
    We're using an MS Access 97 database that's stored on the network. There are three users accessing this database and two are able to get to it just fine, so the problem must be on the third user's machine. The error message is "Out of MS-DOS file handles." The fix suggested on Microsoft's site does nothing. We have checked the user's memory, file paths, etc. and have had no luck. Someone suggested relinking the tables in the database, but that shouldn't be necessary because the other two users are having no problems. I don't want to relink the tables because it could cause more problems and then none of the users would be able to access the database and I wouldn't get to go to lunch. Any suggestions? Thanks.
     
  2. micb

    micb Minimodder

    Joined:
    4 Sep 2002
    Posts:
    1,949
    Likes Received:
    2
    No matter what people say MS Access is not a multi-user database.

    You are coming up against the classic basic windows file access issues.

    MS Access has a very limited locks/read only system but it is not surposed to be used as a multi access system for users.

    To do proper concurrent database access you need to use a proper database like Oracle or MySQL.
     
  3. Arthur2Sheds

    Arthur2Sheds Jackson

    Joined:
    19 May 2003
    Posts:
    817
    Likes Received:
    1
    Thanks for your help. After two days, the problem miraculously 'went away' (sorry I didn't repost; I thought the thread was dead). I wish we could use a MySQL db, but I have no say-so as I am only a student employee. This is the same organization that made Oneseventeen undo all his hard work making the web site standards-compliant because of older users using Netscape 4.x and refusing to upgrade. Thanks anyway!
     
Tags:

Share This Page