Microsoft Access error 3042 - Out of MS-DOS file handles

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.

Thanks to the folks who figured out the problem and replied

Groups.Google posting

(aka Out of MS-DOS handles)

[ Main Access | Main ]