Where do I find PKs for server views? (3 Viewers)

[kentgorrell]

I'm about to do a thorough testing on Server Views, They've been a bit flaky ever since the RefreshLink issue. I worked my way around all that at the time and everything works... mostly.

This week I imported all my objects including tdf links into a fresh container. After that I had one message telling me I had duplicate PKs for a view. How does that happen?

Now I want to do a thorough review of the methods that I use to link views and create PKs. Rather than me spending hours searching through Msys tables and iterating tdf collections, can anyone point me to exactly where I'd find the PKs for views?

 

[Minty]

You can see them in design view of the Linked View.
If you want to see them in code have a look at the answers here:

Retrieve list of indexes in an Access database

I know there's a way to get a list of all tables in an Access database by using the quering the MsysObjects: SELECT MSysObjects.Name FROM MsysObjects WHERE Left$([Name],1)<>'~' AND Left$...

stackoverflow.com