>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?

You may be running into operating system set limits; in Win9x, you may want to expand the number of open files allowed by adding a FILES= statement to CONFIG.SYS; by default, the value selected by Win9x is 'way too low for many applications, and setting the value explicitly (you can use a number between 10 and 254, I beleive the default is 30 or 40) you can normally avoid this error.

If you're running with an old NetWare install using the real-mode drivers, you may need to change the FILE HANDLES = value in NET.CFG or SHELL.CFG; the total of the CONFIG.SYS value and the FILE HANDLES = value can't exceed 254.

You can set the limits in NT in CONFIG.NT