>I'm using mostly private data sessions (VFP 6) and some of my forms open many files. Recently I've started encountering problems with "Too many files open" or "File access denied", which I think stems from the same thing. Is there a limit on the number of files I can open? How do I get around this?

Under Win9x I believe the maximum # of open files is 255. You can put a FILES=255 line in CONFIG.SYS. If you're using a 16-bit Novell client to access files on a Novell server, you may need to tweak FILE HANDLES in the NET.CFG file. Ed Rauh has posted some good messages on this topic recently - you could search for them.

If your app really does need to open more than 255 files simultaneously, you'll need some other approach. Or maybe go to Windows NT - I don't know what its simultaneous open file limit is.