Windows Out of MS-DOS File Handles

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.

 

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.

 

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!