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

Selasa, 25 Desember 2012

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

Duane,

Thanks for the input. I generally compact whenever I encounter a problem or create a new version. Evidently missed it. How often do you recommend compacting?

Thanks!
Connie

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> The first thing I would do is regularly compact the files. The app file is about twice the size of the compacted version and the data file will compact to about 1/4 size. Duane Hookom MVPMS Access
> > To: MS_Access_Professionals@yahoogroups.com
> > From: no_reply@yahoogroups.com
> > Date: Sat, 22 Dec 2012 03:06:23 +0000
> > Subject: [MS_AccessPros] Re: That darn "too many databases" error.
> >
> > Hi Bill :-)
> >
> > I'm happy. Cause I have help! Cause I was able to get rid of the message for now! I used the working table scenario and it's gone. I would love it if you/anybody had more input so that I could decrease the potential of it happening again. I will upload my most recent database.
> >
> > You may have noted that Clive later inferred that I might be getting a Christmas present when I come back from Christmas! So I'm guessing that he might be checking it out.
> >
> > FYI the form that has the most queries underlying it is CustomerList and the similar form CustomerListAllContactInfo which is the first form that is opened in the process where I encountered the "cannot open" message. The RecordSource is WorkingCustomerListInfo4One table and underlying that is qCustomerListInfo4One. A key underlying query is the qCustomerList_2UnionBasicData which is a compilation of 6 queries. I tried to remove the Contacts tables and qCustomerListContactNameSpID queries from each of those 6 queries so that I could use them just once after the UnionBasicData but ended up getting the dreaded message. I added the WHERE parameters gradually, testing as I went and had gotten through one or two of the underlying queries when I got the dreaded message. It is now in its former working state.
> >
> > So I'm wondering whether I should somehow create a working table for the UnionBasicData query behind the final working table to prevent future problems?
> >
> > I love you! (Can you tell I'm happy??)
> > Connie
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> > >
> > > Hi Connie
> > >
> > >
> > >
> > > Did you get the help you needed?
> > >
> > >
> > >
> > > Regards,
> > >
> > > Bill
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > > Sent: Friday, December 21, 2012 9:10 AM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: That darn "too many databases" error.
> > >
> > >
> > >
> > >
> > >
> > > 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
> > > <mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> > > > [mailto:MS_Access_Professionals@yahoogroups.com
> > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of mrsgoudge
> > > > Sent: Wednesday, December 19, 2012 1:18 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > <mailto:MS_Access_Professionals%40yahoogroups.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]
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>