Connie
Access adds indices for the foreign keys if I remember right. Those don't show up in the index property box.
Another thing to turn off is the automatic indexing. If you look under Access Options>Object Designers>Table Design View you'll find key words listed for adding indices without you knowing it. Clear out that list.
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Hi Clive,
>
> Thanks sooooo much for the input! I really appreciate you're taking the time to bless me!
>
> As the db morphed and I changed some things, I didn't check the indexes, so many of the HomeInfo indexes are now unneeded.
>
> I do have a question. The Listings table does need quite a few indexes since I'm searching for several fields (beds, baths, CurrentListing, etc.) When I use your code it says there are 17 indexes. The list of indexes shows 11. (5 of those have ID at the end.) What's up?
>
> Thanks!
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@> wrote:
> >
> > 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 (17) |
Tidak ada komentar:
Posting Komentar