ACCESS FEED: [MS_AccessPros] Re: That darn "too many databases" error.

Minggu, 23 Desember 2012

[MS_AccessPros] Re: That darn "too many databases" error.

I'm using Access 2013 but after 23 iterations of step 6 I still hadn't had any error messages, I just get your "Contact is in a current looking event..."

One thing I noticed was that the queries call VBA routines, especially "ConcatRelated" which in turn goes to the DB via DAO. This is a kind of recursion which is, at best, difficult to debug as it jumps in and out of VBA and the DB Engine for each record. If the DB Engine for some reason cannot cache and reuse the connections then it wil reopen the Db and the codedb (the same db) multiple times.

I haven't spent any time to decode what the query and the ConcatRelated function are trying to do but, can you split the query so that it doesn't have to call a VBA Routine which then goes to the database?

(Alternative, do you find that the error is reduced if you run the db in a directory that is not quite so many levels deep in the directory structure? On my machine I had it unter C:\temp and the short path *might* have helped. If a shorter path helps on yur machine too then this is one more clue.)

--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Bill ,
>
> THANK YOU! Your "You must know by now we will help in any way we can. Upload a sample, zipped db and I bet a lot of us will jump on it." -- made me tear up. You have no idea how much this means. Had forgotten to email myself the back end so that I could upload it on my day off if you guys were game. So had to wait til today.
>
> I'm uploading the whole db since it would take forever to give a sample plus I think the number of records could be part of creating this. I can delete what I've uploaded after a couple of days right? Any and all input on how to create a better product the next time are welcomed. At this point, I need to just make this one work as quickly as possible.
>
> The steps to creating the problem are:
> 1. Click "Info for 1 Contact" button
> 2. Type in Jordan, Esther
> 3. Click NonAER Contacts or Services
> 4. Click Prop
> 5. Click Sold or Off Info or Change
> 6. In Buyers or Contacts portion add Jordan, Shane and tab. It should pull up the message. To make sure you can duplicate it again, delete Jordan, Shane's line.
>
> If it doesn't, keep going and it should come up soon.
> 7. On the Status portion of the Contacts form the Status portion add "Past Buyer", year, etc. Then close form.
>
> Thanks!
> Connie
>
>
>
>
>
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Connie
> >
> >
> >
> > You must know by now we will help in any way we can. Upload a sample, zipped db
> > and I bet a lot of us will jump on it.
> >
> >
> >
> > Then again you might not hear from anyone until the holidays have run their
> > course.
> >
> >
> >
> > Regards,
> >
> > Bill
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > Sent: Wednesday, December 19, 2012 1:18 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] That darn "too many databases" error.
> >
> >
> >
> >
> >
> > Hi all,
> >
> > The long and short of this is that I'm wondering if anybody would have time to
> > take a gander at my database? (Remembering of course that I started this as a
> > novice so there's a bunch of ... ;-) ).
> >
> > I'm back to getting the too many databases error.
> > --I tried changing the vba from db to dbPerm which is a public variable that
> > someone suggested long ago. No good. Most of the db is back to Dim db and
> > Setting to nothing on exiting except for the few potential offending forms.
> > --I've imported it into a blank database.
> >
> > I have stepped through the code and when I do, I don't get the "too many
> > databases" message but the last form (contacts) is frozen.
> >
> > The message can be duplicated. When I tried an older database it was the same,
> > so I've just not been using this feature.
> >
> > As you would probably guess, I'm discouraged. Usually I'm a like a dog with a
> > bone and I won't give up, but right now I have no idea what else to try.
> >
> > Thanks for your help,
> > Connie
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>