"Cannot Open any more databases" error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
Back
Top