Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

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.
0
mosammey
Asked:
mosammey
3 Solutions
 
tbsgadiCommented:
Hi mosammey,

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


Good Luck!

Gary
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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 ArchitectCommented:
".  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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now