>Here is a problem for DB gurus;
>
>My application contains 50-70 tables which are stored in the primary DBC.
>
>In the old days I would create many forms and select 5-8 files to support each form.
>
>Today I create one form with 8 tabs. I then load each table from my DBC into the one form.
>
>Question
>
>Do form containers have a limit as to the number of files that can be opened?

From MSDN: "Maximum # of tables open at one time: 255 (Limited by memory and available file handles. .cdx files use only one file handle)"

>Should I be making several forms with 5-10 files instead?

Depends on what the user like most. If you don't want to open all the tables at the form startup, you can open the tables only when the tab is selected the first time.

HTH