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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar