Hi all: i am trying to connect to a (networked) third party SQLServer db with multiple PK that produce said error.
Initially i thought i could 'workaround' with SYNONYM, but i believe that it is (for example) the "PK_dbo.atrule" syntax that is causing the
"Linked table" routine to fail.
Frankly i don't know how to use SYNONYM in the LINK TABLES wizard even in tables without the offending PKs.
any enlightenment would be most appreciated
- if necessary i would just as soon create a duplicate database (with re-named keys) if i could be sure i could keep it transactionally synchronized.
many thanks
sample table
table: dbo.atrule
columns: id, id_user, pattern_match, etc.
Keys: PK_dbo.atrule