access 2007 cannot open any more databases

[n8kindt]

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?

[missinglinq]

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)>

[n8kindt]

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