Accessing backend data through a form. Err:Can't open any more DB

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

Guest

I've got a major problem with my Access 2002 that started when I split the
database between the data and the rest of the Access database. When I did
this I had to change a lot of the dlookups on my forms to ADODB queries
because I was getting this "Cannot open any more databases" error. Now I'm
finding that my combo boxes are getting the same error or they are not
returning any data.

I think the source of the problem is that my form and
combo boxes are all pulling data through the Jet links to my backend database
an apparently each linkup or query accross the links opens a database. Now
I'm trying to load my forms through ADO to avoid this problem and I am
hitting a dead end because I cannot find a way to link a form to a backend
database except through the Jet links.

To magnify the problem my application may have 3 or 4 forms open at any
point in time. I also use a ton of Combo boxes to make selections from.

Can someone help me?
 
First, why are you using DLookups in the first place? That's pretty much for
one-shot lookups (as in "I want a single column and that's it" kind of
thing.) If your combo boxes are using standard Access querires, it shouldn't
be a problem either. I'd get rid of all the DLookups (how many do you have?)
 
Dennis,

In my original note I mentioned that I was getting out of the Dlookups. I
mentioned them because they are clues to the real problems that I am having
which is that my forms and combo boxes are routing through the links
established in JET.

The real issue is how do you change the data source in a form to route to a
backend database. I'm in Access 2002 and (1.) I don't know if 2002 can do
what I want, and (2.) if it does, how do you do it?

Another clue to this problem is that I have a lot of forms that call up
other forms and I also use a lot of Combo Lists on those forms. As near as I
can figure out, Access opens a "database" every time I open a form and every
time I open a combo box. When I have a half dozen forms and 50 to 75 combo
boxes going through JET to the backend database, it chokes and gives me an
error "Cannot open any more databases"

This error seems to occur with as few as 3 forms and 2 combo boxes open
which tells me the system can only open up 5 to 10 databases although I
cannot find any documentation stating that fact.
 
Back
Top