473,546 Members | 2,644 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

access 2007 cannot open any more databases

n8kindt
221 New Member
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
2 7159
missinglinq
3,532 Recognized Expert Specialist
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
221 New Member
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

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

Similar topics

2
1860
by: edo | last post by:
100 Day Analysis Following is a summary of articles spanning a 100 day period, beginning at 10 Sep 2003 06:41:30 GMT and ending at 19 Dec 2003 04:09:06 GMT. Notes ===== - A line in the body of a post is considered to be original if it
37
5183
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end...
9
3818
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. ...
13
13233
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine company. They presently have about 4 networked computers, all running Windows XP (w/SP2) and Microsoft Office 2000 (specifically Access 2000) - and a...
0
2026
by: Philippe Geril | last post by:
GAME-ON 2007 November 20 - 22, 2007 CALL FOR PAPERS University of Bologna Bologna, Italy Organized by EUROSIS-ETI
16
11048
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in...
2
3782
by: ARC | last post by:
Just curious if anyone is having issues with Acc 2007 once the number of objects and complexity increases? I have a fairly large app, with many linked tables, 100's of forms, queries, reports, and lots of vba code. I'm nearly finished with re-doing my app in access 2007, and just imported an add-in program, which has added even more forms,...
7
23851
by: preeny8 | last post by:
Hi there, I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with. I worked with a lot of databases in Access 2003 (.mdb), and for some reason some of these databases will not open in access 2007. The errors I get say: "An error occured while loading 'Form_frm_tabstrip'. do you want to...
5
10521
by: Lysander | last post by:
My collegue had to buy a new laptop that came with Office 2007 already installed. She had Access 2003 installed on top, in a different directory. None of our 2003 databases will run on her laptop, all giving the error "Form Open- Event, property does not exist" or something like that. This happens with every form. We can access the...
0
7504
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7435
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7694
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7947
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
5360
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3491
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3470
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1921
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
747
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.