By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

access 2007 cannot open any more databases

n8kindt
100+
P: 221
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?
Mar 28 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Here's three links to posts that discuss the problem. BTW, it seems to run across all versions of Access.

http://www.dbforums.com/showthread.php?t=722511
http://www.access-programmers.co.uk/...d.php?t=122973
http://www.utteraccess.com/forums/sh...2&Main=1498307

Linq ;0)>
Mar 28 '08 #2

n8kindt
100+
P: 221
Here's three links to posts that discuss the problem. BTW, it seems to run across all versions of Access.

http://www.dbforums.com/showthread.php?t=722511
http://www.access-programmers.co.uk/...d.php?t=122973
http://www.utteraccess.com/forums/sh...2&Main=1498307

Linq ;0)>
thanks for your help! i appreciate it! wow, i'm surprised i didn't come across some of those sources myself. that should do the trick. thanks for your time!

cheers,
nate
Mar 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.