Hi Connie,
Hope your problem has gone away but I suspect that there
could be a problem with the BackEnd Db.
I found that there are three tables with probably too many
indices(Indexes), a typical cause of poor performance and
a potential cause of the "Too many..." messages.
I have uploaded the file "Indexes.txt" to the
2_AssistanceNeeded folder, with some code to use in the
DebugWindow to show the state of the three tables with
a high Index count.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> I just got back from Christmas in the Cities motivated to get this off my plate only to find that the last upload did not have the proper Back End. I apologize to anybody that tried to work with it. Will check it out when I get back to work tomorrow.
>
> Thanks again,
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> >
> > 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
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (15) |
Tidak ada komentar:
Posting Komentar