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