Out of MS-DOS File Handles

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry Real - 26 Nov 2003 17:11 GMT

I have put together a very simple database with 5 tables
and a couple of queries in Access 97. When I converted
this to Access 2002 on one of my colleagues PC's
(networked), I kept getting the 'Out of MS-DOS File
Handles' when trying to run any of the two queries.

I believe file handles are no longer used so what could
this be? Any ideas??

Reply to this Message

Tony Toews - 29 Nov 2003 23:02 GMT

>I have put together a very simple database with 5 tables
>and a couple of queries in Access 97. When I converted
>this to Access 2002 on one of my colleagues PC's
>(networked), I kept getting the 'Out of MS-DOS File
>Handles' when trying to run any of the two queries.

Out of MS-DOS file handles - error 3042 Microsoft Access
This is a strange problem caused by, of all things, security problems.
Ensure the permissions are read/write to the MDB. Actually it should
really be read/write/delete for the entire directory otherwise the
permissions on the MDB itself will be lost when the MDB is compacted.
http://www.granite.ab.ca/access/error3042.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message