Pseudo index

[Mike]

When you add a linked table in Microsoft Access, it open the linked table
manager to let you assign a unique index. By doing that the linked table
manager create a pseudo index on that table.

I want to read back the pseudo index, and get back what the user have
chosen through the linked table manager for the unique index.
How do we do that!!!!!

I just want to get back the value of the pseudo index.

I am able to read back (ADOX) the primary key and index of a local table
in Access and see all the field that create the index or primary key, but I
am unable to do the same thing with pseudo index.

Where do that linked table manager have save the unique index.
It's got to be somewhere

Thanks!!

 

[Douglas J. Steele]

If they've created such an index, it's named __UnigueIndex (that's two
underscores at the beginning)

I show how to get the details using DAO at the bottom of
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

 

[Mike]

Thanks a lot for the help, It's a nice exemple.

If they've created such an index, it's named __UnigueIndex (that's two
underscores at the beginning)

I show how to get the details using DAO at the bottom of
http://www.accessmvp.com/DJSteele/DSNLessLinks.html