"Too many databases" does not literally mean "databases" but can be taken to
mean "Too many connections to tables". Connections to tables primarily come
from queries, aggregate functions and linked tables. When you imported
copies of the backend tables, the only connections you had were queries and
aggregate functions. Linking to the backend tables created connections to
tables. These additions caused your database to exceed the max allowable
connections and you get the error. You are going to need to review the
design of your database and try to reduce the connections to tables.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
<jn****@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
I have a database in A2003 format that's giving me this error, but it's
not the same situation I've been reading about on here. In my
development copy, I have imported copies of the backend's tables, and
everything works fine. I can also compile the database like this, and
it works fine. However, as soon as I get rid of these copies and
instead link to the real data, I get the "can not open any more
databases" error. Why would it make a difference?
I have a lot of saved queries as the data manipulations I need are
pretty complicated (for me) and I need to build on other queries to get
to the final product. If this is the problem though, why would it only
show up when I used linked tables instead of imported ones?
Any thoughts or info would be greatly appreciated. Thanks.
-Josh Nikle