i'm stuck. i'm using access 2007 on a windows vista machine (i've tried running on xp too, though--same result) and this is the error i keep getting whenever i try running my main query:
Cannot open any more databases. (Error 3048)
You have reached the limit on the number of databases that can be opened at one time. Close one or more databases and try the operation again.
this suggestion is not very useful to me. i have one backend database storing the raw data and this one that stores the queries, forms, reports, and modules but the suggestion of closing a database obviously does me no good.
i was having this error occur earlier after running my report (which runs off the query) more than 3+ times yesterday. and after looking through the forums, i found a suggestion to normalize my data to eliminate this error msg. so after going from one great big table to 4 smaller ones, now i cannot even run the query. i thought it might be b/c i was using a subreport and it sapped too much memory but now that theory is out the window. i should also mention that smaller queries still run, but even average size queries sometimes fail with this error.
does anyone have any ideas of what i can do to work around this?
Cannot open any more databases. (Error 3048)
You have reached the limit on the number of databases that can be opened at one time. Close one or more databases and try the operation again.
this suggestion is not very useful to me. i have one backend database storing the raw data and this one that stores the queries, forms, reports, and modules but the suggestion of closing a database obviously does me no good.
i was having this error occur earlier after running my report (which runs off the query) more than 3+ times yesterday. and after looking through the forums, i found a suggestion to normalize my data to eliminate this error msg. so after going from one great big table to 4 smaller ones, now i cannot even run the query. i thought it might be b/c i was using a subreport and it sapped too much memory but now that theory is out the window. i should also mention that smaller queries still run, but even average size queries sometimes fail with this error.
does anyone have any ideas of what i can do to work around this?
Comment