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 7 2553
"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
PCD wrote: "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.
Connections come from aggregate functions?
--
To anyone reading this thread:
It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first. http://home.tiscali.nl/arracom/whoissteve.html
Randy Harris
You are nothing but an OBSESSED, egocentric A$$ just like your pal Arno R.
You need to also take the advise that was given to Arno R by a poster not
too long ago and grow up and get a life. We don't need the likes of you and
Arno R in our newsgroup! Just get lost and quit filling our newsgroup with
your slanderous
garbage!!!!!!
--
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
"Please Stop Advertising" <pl****@no.spam> wrote in message
news:nn******************@newssvr21.news.prodigy.c om... PCD wrote: "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.
Connections come from aggregate functions?
-- To anyone reading this thread:
It is commonly accepted that these newsgroups are for free exchange of information. Please be aware that PC Datasheet is a notorious job hunter. If you are considering doing business with him then I suggest that you take a look at the link below first.
http://home.tiscali.nl/arracom/whoissteve.html
Randy Harris
"PCD" <no***@email.com> wrote You are nothing but an OBSESSED, egocentric A$$ just like your pal Arno R. You need to also take the advise that was given to Arno R by a poster not too long ago and grow up and get a life.
Steve, it is certainly nice to see someone who can let adverse comments
roll right off their back. It is too bad you are not one of those
"someones." Do you have an idea that this kind of rant is likely to _help_
you get customers from the newsgroup?
Larry Linson
They are not "adverse" comments. They are OBSESSED, egocentric comments made
by a couple of A$$s!!!!
"Larry Linson" <bo*****@localhost.not> wrote in message
news:OyIVf.3521$Od7.41@trnddc06... "PCD" <no***@email.com> wrote
You are nothing but an OBSESSED, egocentric A$$ just like your pal Arno R. You need to also take the advise that was given to Arno R by a poster not too long ago and grow up and get a life.
Steve, it is certainly nice to see someone who can let adverse comments roll right off their back. It is too bad you are not one of those "someones." Do you have an idea that this kind of rant is likely to _help_ you get customers from the newsgroup?
Larry Linson
thanks for the clarification (about the error, not a$$es). i realized
my deign was, well stupid, and made some changes. the error's gone.
thanks.
-josh
You are welcome!!
BTW, the clarification about the A$$s was also legitimate! Arno R does not
make any contributions to this newsgroup but is driven by his obsession to
be the champion of the newsgroup when INDEED all he is doing is showing all
newsgroup readers that he is just an egocentric A$$!!
<jn****@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com... thanks for the clarification (about the error, not a$$es). i realized my deign was, well stupid, and made some changes. the error's gone. thanks.
-josh This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Niranjan |
last post by:
I have a relatively straight forward report. The query that populates
data for this report is complicated. The report opens without any
problem and I can print it as well.
However, If I have...
|
by: Susan Bricker |
last post by:
Greetings Experts ...
I have a routine that is invoked when a command button is clicked. The
button is located in a form that is tied to a table of Project records.
Each Project Record has 0 to...
|
by: RC |
last post by:
In my Access 2002 form, I have a combo box and on the AfterUpdate
event I use
DoCmd.RunSQL ("UPDATE ....
to update records in a table. When it starts to run I get a message
"You are about to...
|
by: MLH |
last post by:
If this is what MySQL is set to...
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum,
qryVehiclesNowners5.VDescr, qryVehiclesNowners5.Owner,
qryVehiclesNowners5.VehicleJobID ,...
|
by: Holly Cross |
last post by:
I have a report that uses several subreports. The report looks fine in print
preview, but when I send it to the printer, I keep getting this message
"Cannot open any more databases." This happened...
|
by: Brian Keating |
last post by:
Hi there I want to get a list of databases on my server so I do this
SqlConnection.GetSchema("Databases");
However is it possible to restrict the Databases to just user databases?
i.e. exclude...
|
by: pike |
last post by:
db2 8.1 FP11 on AIX 5.3.0.0 .
The db2diag.log is intermittently reporting EMFILE (24) "Too many open
files" errors. The culprit is always db2hmon. Sample db2diag.log
output follows:
...
|
by: DrVitoti |
last post by:
On that program the compiler says "parse error" on line 8, 10, 12 and 21, it also says "too many arguments" on lines 10, 12 and finally it says "at this port in" on lines 13, 14, 20 . How could I...
|
by: RayOsborn |
last post by:
I have some old "shelve" databases created in Python 2.2 that use the
old bsddb format, whereas the version of Python 2.4 installed by my
web hosting service doesn't have bsddb available at all...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |