"Cannot Open any more databases" error message

[Annie]

I have a form with numerous subforms on it. I've been developing it on my
personal PC. A few times I've gotten the error message "Cannot Open Any More
Databases" when I try to open this form. Any ideas what is causing this?
More often than not I have no problems working with this form.

Thanks!

 

[Annie]

I figured it out. I forgot to mention that I just split the database
yesterday and the backend now resides on a server. The problem is that now
that the database is split, I'm running out of table handles, or TableIDs.
Jet 4.0 has a limit of 2048. Linked tables, which are used in a split
database, use twice as many TableIDs. TabkeIDs are also used by queries,
modules for forms, combo boxes and list boxes whose row source is a table or
query, DAO recordsets, and domain functions such as Dlookup. My form is very
complex, and splitting the database caused my use of TableIDs to exceed the
limit. Thanks!