MS Access: Cannot open any more databases. (Error 3048)

I know that a variety of questions have been asked for Error 3048:  Cannot open any more databases, but I do not think that they fully deal with the problem that I am having.  I would also like to add that I am very new to programming.

I am using MS Access 20003 to create a query.  This union query that has 13 SELECT statements, and once the query is ran I receive the error message saying that no more databases can be open.  Is there any way around this?  I am selecting all of this information for one summary report within the program.
mosammeyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tbsgadiCommented:
Hi mosammey,

You can make a "Temporary Table" out of part of the query, ie do it in stages.


Good Luck!

Gary
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Unfortunately, your going to have to re-design the process in some way.  Access has several internal limits (number of DB's it can open, number of fields it can deal with, etc) and your bumping into that.   There is no way to change these.
What you might try is to shorten table and field names.  That on occasion will get you working again, but it's not a guarantee.  The error messages are often mis-leading and often are cause by something un-related.  
 You might want to consider importing the data into a temp table so you can have a SQL Select against a single table.
JimD.
0
mosammeyAuthor Commented:
Gary,

Thank you for the very fast response.  I did see where someone suggested creating a temp table to someone else, but when I could not find any good information for creating a temp table for the report.  
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

tbsgadiCommented:
You can start your union query ,say with 7 Select Statements & see if you have a problem.
If not then you make a Make-Table or append Query from that,  and then add that temp table to the next 6 Select Statements.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
".  This union query that has 13 SELECT statements'

Do your SELECT statements involve multiple tables and/or subqueries ?

I have a UNION query with 20 SELECT statements (on single tables) - which get data from temp import tables and display some calculations.  I have no issue with this error.  

I had this error the other day in a code loop (using DAO) because I left out a line of code - basically creating an endless loop.  Of course, that was easy to spot and fix.

mx
0
mosammeyAuthor Commented:
Thanks everyone for your help.  I have been really busy at work and I apologize for not responding sooner.
0
tbsgadiCommented:
Glad to help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.