Results 1 to 2 of 2
Thread: Primary Key Disappears (2003)
2004-09-08, 08:35 #1
- Join Date
- Sep 2002
- London, England
- Thanked 0 Times in 0 Posts
Primary Key Disappears (2003)
I have a 2003 contacts database that has twice now lost the primary key to the main contacts table. The database is a backend on a network server used by five people with 2003 front ends installed on their workstations. The users insist that they have not opened the back end and messed with anything, so I'm wondering if there are any known situations where a primary key can spontaneously disappear.
One point that may be relevant is that the problem table has a lot of indexes (23 including the PK). One of the main functions of the database is to allow the users to allow the users to create ad hoc filters on most of the non text fields, which is why I added so many indexes. However, I wonder if I have made the table unstable by doing this?
2004-09-08, 11:37 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 37 Times in 36 Posts
Re: Primary Key Disappears (2003)
I'm not sure if the limit still applies to Access2003, but prior to that a table could have no more than 32 indexes AND relationships. This is even more constrained by the hidden indexes Access creates on a table when it is on the "many" side of a one-to-many relationship (with enforced RI). You might want to download my Documentor utility (follow the link below) which allows you to see all the indexes and relationships on a table. Be sure to check for what are essentially duplicate indexes; that is, where you created an index that duplicates an index Access has already created.