Ms DoS Handles

[Bob&Tam]

I have code in one of my access DBs which relinks about 20tables.
On certain PCs when this is done, i get the message - run time error 3042 - out of msdos handles.
I have update the config.nt file to include files=150, as the help instructed me to do this but I still get the same problem.

This is only happening on certain PCs - is this a memory issue???

any ideas?????

 

[MrTibbs]

Ideas and questions:
Are you dropping the previous links before re-linking?
Which version of Access are you using ?
Under what circumstances does it occur? Does each PC work OK for a while after re-booting the pc?
Does it work OK if you disconnect some existing users?
Is this linking to shared databases on a server ? Are the server's file handles running out?

 

[Bob&Tam]

Yes the links are being dropped first.
Access 97.
Works for certain PCS - nor for others!
After a reboot with no other users acessing the backedn - it still doesn't work!

Yes, it is linking to a shared database!