I
ipk*
lost once more ...
i get the above error (can not open anymore databases) when i try to open a
form containing 30 subforms ("subquestion" about this in the end) ...
funnly, the ol search machine tells me the one and most important thing to
do is to split my database in front and backend. now the thing is, i have
already done so, and the error goes away if i delete the linked tables and
import them (rather than linking). so that is not it. there is also no db =,
set db, or openrecordset code involved.
nevertheless, it must be some problem with too many open connections to the
jet engine or so. if i reduce the number of subforms to 24, the error also
goes away with keeping the tables linked in, rather than imported.
all of the 30 subforms have basically the same underlying query, with two
parameters different.
why do i have to do this (and there goes my "subquestion") ? i want to
display a 2 dimensional matrix with 4 rows and 6 columns. each element of the
matrix contains 6 rows that i pull with the underlying query. like having a
chessboard and i want to show how many grains of rice, corn, wheat and barley
are on each square (and, of course their size and how dark they are roasted
etc ...
the underlaying tables have the data for a few 100 different chessboards, i
decide for one chessboard, pull up the form with the 30 subforms, for each
subform a generate (via vba) a query as recordsource that contains the
specific row and column for that specific square ...
oh my ... can anybody follow ?
if so ... can you help me ???
thanks, again ...
ingo
i get the above error (can not open anymore databases) when i try to open a
form containing 30 subforms ("subquestion" about this in the end) ...
funnly, the ol search machine tells me the one and most important thing to
do is to split my database in front and backend. now the thing is, i have
already done so, and the error goes away if i delete the linked tables and
import them (rather than linking). so that is not it. there is also no db =,
set db, or openrecordset code involved.
nevertheless, it must be some problem with too many open connections to the
jet engine or so. if i reduce the number of subforms to 24, the error also
goes away with keeping the tables linked in, rather than imported.
all of the 30 subforms have basically the same underlying query, with two
parameters different.
why do i have to do this (and there goes my "subquestion") ? i want to
display a 2 dimensional matrix with 4 rows and 6 columns. each element of the
matrix contains 6 rows that i pull with the underlying query. like having a
chessboard and i want to show how many grains of rice, corn, wheat and barley
are on each square (and, of course their size and how dark they are roasted
etc ...
the underlaying tables have the data for a few 100 different chessboards, i
decide for one chessboard, pull up the form with the 30 subforms, for each
subform a generate (via vba) a query as recordsource that contains the
specific row and column for that specific square ...
oh my ... can anybody follow ?
if so ... can you help me ???
thanks, again ...
ingo