Don't understand the relationship between a combo box and a table
in [Getting Started]
|
Prev: "stretch-to-fit" text box for Report
Next: Don't understand the relationship between a combo box and a ta
From: forest8 on 30 Mar 2010 18:54 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: Jeff Boyce on 30 Mar 2010 19:09 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: Duane Hookom on 30 Mar 2010 21:42 I would also add that most of us don't care for multivalue fields. Do you care to share what you are storing in your table? -- Duane Hookom MS Access MVP "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:elOUg4F0KHA.1236(a)TK2MSFTNGP06.phx.gbl... > 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 W. Vinson on 30 Mar 2010 22:10
On Tue, 30 Mar 2010 15:54:02 -0700, forest8 <forest8(a)discussions.microsoft.com> wrote: >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 My guess is that these combo boxes have indexes of their own which contribute toward the form's index count. I would *VERY STRONGLY* suggest that putting combo boxes into a table - particularly multiselect combo boxes - is a major misuse of Access, and that it is unnecessary! Table datasheets are becoming more complex with recent releases of Access, but they're still *very limited*. There is nothing that you can do with a complicated table that you cannot do with simple, properly normalized tables, and a well designed Form. You do NOT need multiselect combos, or any combos at all, in your Table in order to do so. -- John W. Vinson [MVP] |