Referential Integrity Generates Index - October 1997

If your MSAccess database uses referential integrity the declaration of the reference creates a ‘hidden’ index in the referencing table.

From the VB Help file - When you enforce referential integrity, a unique index must already exist for the key field of the referenced table. The Jet database engine automatically creates an index with the Foreign property set to act as the foreign key in the referencing table.

Loading Indexes Into an Array

I spent 2 hours trying to figure out why I was getting an unwanted index while using the following routine. I had to add the test for the ‘Foreign’ index. The following routine loads an array with ‘Standard’ indexes. The ‘Foreign’ index is not loaded. Maybe this tip will save you two hours someday.

Download As Word 97 Document

Click here to download this page as a zipped Word 97 Document [5k].

Previous Tip    Tip Index    Next Tip


Updated 2000/10/29