Too many indexes - Wierd hidden indexes preventing index add 
Author Message
 Too many indexes - Wierd hidden indexes preventing index add

I have a client database that is sick. When I run update code against the DB
that adds an index to the table - it fails because too many indexes exist
(32). When you examine the DB in design mode only 5 are displayed.
Using DAO code - I can see all 32 - the first being rather strange.
Here is output of code that displays index and fields.
32 Indexes in tEnrollment TableDef
    {2E912908-36A3-11D2-B87A-00104B945169}+Account
    {2E91290A-36A3-11D2-B87A-00104B945169}+Student
    {95AD7704-4261-11D2-B881-00104B945169}+Account
    {95AD7705-4261-11D2-B881-00104B945169}+Student
    {95AD770B-4261-11D2-B881-00104B945169}+Account
    {95AD770C-4261-11D2-B881-00104B945169}+Student
    {95AD7714-4261-11D2-B881-00104B945169}+Course
    {95AD7715-4261-11D2-B881-00104B945169}+Student
    {95AD771D-4261-11D2-B881-00104B945169}+Student
    {95AD7724-4261-11D2-B881-00104B945169}+Student
    {95AD772C-4261-11D2-B881-00104B945169}+Course
    {95AD772D-4261-11D2-B881-00104B945169}+Student
    {B6CE0864-3B3F-11D2-B87E-00104B945169}+Account
    {B6CE0865-3B3F-11D2-B87E-00104B945169}+Student
    {B6CE086C-3B3F-11D2-B87E-00104B945169}+Account
    {B6CE086D-3B3F-11D2-B87E-00104B945169}+Course
    {B6CE086E-3B3F-11D2-B87E-00104B945169}+Student
    {C52CA144-40F4-11D2-B880-00104B945169}+Account
    {C52CA145-40F4-11D2-B880-00104B945169}+Student
    {C52CA14B-40F4-11D2-B880-00104B945169}+Account
    {C52CA14C-40F4-11D2-B880-00104B945169}+Student
    {C52CA153-40F4-11D2-B880-00104B945169}+Account
    {C52CA154-40F4-11D2-B880-00104B945169}+Course
    {C52CA155-40F4-11D2-B880-00104B945169}+Student
    {C52CA15D-40F4-11D2-B880-00104B945169}+Account
    {C52CA15E-40F4-11D2-B880-00104B945169}+Course
    {C52CA15F-40F4-11D2-B880-00104B945169}+Student
    PrimaryKey+Student;+Course
    Reference1+Account
    Reference2+Course
    Reference3+Student
    SerialAccount+SerialEnrollID

They are there but don't show up in index properties in GUI.
Any suggestions for a repair process.  I would like to just run code to
delete the funny ones.


Sat, 06 Oct 2001 03:00:00 GMT  
 Too many indexes - Wierd hidden indexes preventing index add
If it has any foreign keys as relationships, those will
count too. If you think it may be just corruption, just
delete all the indexes and recreate them.

Michael


Quote:
> I have a client database that is sick. When I run update
code against the DB
> that adds an index to the table - it fails because too
many indexes exist
> (32). When you examine the DB in design mode only 5 are
displayed.
> Using DAO code - I can see all 32 - the first being rather
strange.
> Here is output of code that displays index and fields.
> 32 Indexes in tEnrollment TableDef
>     {2E912908-36A3-11D2-B87A-00104B945169}+Account
>     {2E91290A-36A3-11D2-B87A-00104B945169}+Student
>     {95AD7704-4261-11D2-B881-00104B945169}+Account
>     {95AD7705-4261-11D2-B881-00104B945169}+Student
>     {95AD770B-4261-11D2-B881-00104B945169}+Account
>     {95AD770C-4261-11D2-B881-00104B945169}+Student
>     {95AD7714-4261-11D2-B881-00104B945169}+Course
>     {95AD7715-4261-11D2-B881-00104B945169}+Student
>     {95AD771D-4261-11D2-B881-00104B945169}+Student
>     {95AD7724-4261-11D2-B881-00104B945169}+Student
>     {95AD772C-4261-11D2-B881-00104B945169}+Course
>     {95AD772D-4261-11D2-B881-00104B945169}+Student
>     {B6CE0864-3B3F-11D2-B87E-00104B945169}+Account
>     {B6CE0865-3B3F-11D2-B87E-00104B945169}+Student
>     {B6CE086C-3B3F-11D2-B87E-00104B945169}+Account
>     {B6CE086D-3B3F-11D2-B87E-00104B945169}+Course
>     {B6CE086E-3B3F-11D2-B87E-00104B945169}+Student
>     {C52CA144-40F4-11D2-B880-00104B945169}+Account
>     {C52CA145-40F4-11D2-B880-00104B945169}+Student
>     {C52CA14B-40F4-11D2-B880-00104B945169}+Account
>     {C52CA14C-40F4-11D2-B880-00104B945169}+Student
>     {C52CA153-40F4-11D2-B880-00104B945169}+Account
>     {C52CA154-40F4-11D2-B880-00104B945169}+Course
>     {C52CA155-40F4-11D2-B880-00104B945169}+Student
>     {C52CA15D-40F4-11D2-B880-00104B945169}+Account
>     {C52CA15E-40F4-11D2-B880-00104B945169}+Course
>     {C52CA15F-40F4-11D2-B880-00104B945169}+Student
>     PrimaryKey+Student;+Course
>     Reference1+Account
>     Reference2+Course
>     Reference3+Student
>     SerialAccount+SerialEnrollID

from.
> They are there but don't show up in index properties in
GUI.
> Any suggestions for a repair process.  I would like to
just run code to
> delete the funny ones.



Sat, 06 Oct 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Listview add index and retrieve index?

2. How can i use INDEX in ADODC - Como usar indices em ADODC

3. Request for help - limitation of 32 indexes including foreign indexes

4. remove index from field or delete a indexed field

5. How to insert data from un-indexed tabel to indexed table

6. Indexes collection contains more indexes that I created????

7. .begintrans w/ .index to prevent record locks

8. Adding fields to a table and index

9. Create Index without adding field!!!

10. Add field to index thru DAO

11. Add field to index thru DAO

12. DAO and Adding Index to a Table

 

 
Powered by phpBB® Forum Software