by I have a project that reads a given SQL database and enumerates the tables
and then the records in them.
I needed to check which field in the table was set as the primary key.
For Each tbl In cat.Tables
If tbl.Keys.Count > 1 Then
'to set the displayed field for the tree control because of
relationships and foreign keys in tables
.... do something
End If
...do something
i = i + 1
End If
next tbl
this worked fine until recently. imust have loaded some patches, probabaly
SQL sp1 & sp 2
anyhow now the tbl.keys.count doesn't ever change and this is confirmed from
the locals window. I have played around with the keys on the table throught
the SQL MMC but nothing works.
Has anyone else experienced this and what was the solution, alternatively
what version of the msadox.dll should i use - i've got 2.6
thanks
john