Solved

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

Posted on 2009-04-06
7
779 Views
Last Modified: 2013-11-28
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
Comment
Question by:mosammey
7 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 250 total points
ID: 24077703
Hi mosammey,

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


Good Luck!

Gary
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 24077728
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
 

Author Comment

by:mosammey
ID: 24077759
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 46

Expert Comment

by:tbsgadi
ID: 24077840
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 125 total points
ID: 24079043
".  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
 

Author Closing Comment

by:mosammey
ID: 31567042
Thanks everyone for your help.  I have been really busy at work and I apologize for not responding sooner.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24188055
Glad to help!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now