Don't understand the relationship between a combo box and a ta
in [Getting Started]
|
From: Jeff Boyce on 31 Mar 2010 12:16 OK, now try running the database documenter on the table(s). See how many indices Access believes you have... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "forest8" <forest8(a)discussions.microsoft.com> wrote in message news:E54624D9-AD82-421D-9154-70B84709C3E5(a)microsoft.com... > When I check the indexes, there are only 2 indexes created: > > One is the tables' primary key and the other is the Foreign Key. > > I can't seem to see any other index. > > > > "Jeff Boyce" wrote: > >> First, be aware that the general consensus among regular Access users is >> that more than about 30 fields in a table is fairly unusual, and usually >> indicates that the table/database needs a bit more normalizing. >> >> Access adds indexes of it's own, "behind the curtain" so to speak. Have >> you >> opened the table in design view, clicked on the Indexes button and >> inspected >> what indices are showing? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> news:20B6C98A-AFB2-47BC-BEE5-3EB31B189138(a)microsoft.com... >> > Hi there >> > >> > Currently I am getting the following message: >> > >> > "The operation failed. There are too many indexes on table 'Orders'. >> > Delete >> > some of the indexes on the table and try the operation again." >> > >> > In my table, I am trying to change a text box into a multi=select combo >> > box. >> > >> > There are 45 fields in my table of which 40 have this multi-select >> > combo >> > box. >> > >> > I don't understand where these indexes are being created. >> > >> > I do have 1 primary key in my table. >> > >> > Thank you >> >> >> . >>
From: John Spencer on 31 Mar 2010 16:55 The indexes you don't see are hidden and will not show up when you use the indexes dialog. They are being created to manage the relationships being set up by all those comboboxes used by the lookup fields. You can detect them by using VBA code to step through the indexes collection for the table. This will give you the count of indexes for a particular table. Enter it into the VA+BA immediate window. Currentdb().TableDefs("NameOfTable").Indexes.Count John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County forest8 wrote: > When I check the indexes, there are only 2 indexes created: > > One is the tables' primary key and the other is the Foreign Key. > > I can't seem to see any other index. > > > > "Jeff Boyce" wrote: > >> First, be aware that the general consensus among regular Access users is >> that more than about 30 fields in a table is fairly unusual, and usually >> indicates that the table/database needs a bit more normalizing. >> >> Access adds indexes of it's own, "behind the curtain" so to speak. Have you >> opened the table in design view, clicked on the Indexes button and inspected >> what indices are showing? >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message >> news:20B6C98A-AFB2-47BC-BEE5-3EB31B189138(a)microsoft.com... >>> Hi there >>> >>> Currently I am getting the following message: >>> >>> "The operation failed. There are too many indexes on table 'Orders'. >>> Delete >>> some of the indexes on the table and try the operation again." >>> >>> In my table, I am trying to change a text box into a multi=select combo >>> box. >>> >>> There are 45 fields in my table of which 40 have this multi-select combo >>> box. >>> >>> I don't understand where these indexes are being created. >>> >>> I do have 1 primary key in my table. >>> >>> Thank you >> >> . >>
First
|
Prev
|
Pages: 1 2 3 Prev: Don't understand the relationship between a combo box and a table Next: Missing reference |