AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Wednesday, June 27, 2012

One more source for Can’t open any more databases

Error message 3048 "Can’t open any more databases" typically occurs when you often call CurrentDB. But one more case when it can happens – if DLookup() functions (like DFirst(), DMax(), etc) are called many times. I was hit by this error in Access report with subreport. Subreport had a call to DFirst(), and when user run report several times plus made report export to PDF – error occurred in very odd places. Look at Allen Browne Extended DLookup() for a replacement.

Labels:

7 Comments:

Anonymous Ben said...

I have created a pop-up form that tells you how many database connections are still available and how many have been used. As you open new forms, it will report on how the availability changes. I have database with a lot of complex queries and forms and would get this error if I opened too many at once. Now that I understand how it works I can track down where all the overhead is being used.

I'd like to share my form but I don't know where to post it. I was hoping you could accept files here. Alex, can you suggest where I can post it?

Ben

12:55 AM  
Blogger Alex Dybenko said...

Hi Ben,
you can put it in skydrive public folder and post linki here. Or send it to my email alexdyb@hotmail.com, i will put it somewhere and add link

9:21 AM  
Blogger yrichter said...

Ben,

If you can share your code that would be a tremendous help. I tried doing the same thing a few years ago but never got it working right.
Thanks,

Isaac Richter

9:55 AM  
Blogger grovelli said...

Has Ben's form been posted anywhere?

2:50 AM  
Blogger Ondine said...

Ben
I'm having trouble with a client who has this error constantly and your form would be a real godsend. Can you post it? Or the code as suggested below?

Thanks!

Ondine

12:39 PM  
Blogger Alex Dybenko said...

Hi Ondine,
it is here:
http://accessblog.net/2014/04/how-many-database-connections-are-still.html

2:10 PM  
Anonymous Anonymous said...

Brilliant, thanks!

Ondine

2:17 PM  

Post a Comment

Links to this post:

Create a Link

<< Home