Linked Tables with Primary Keys? jhcoxx[ at ]hotmail.com 06.06.2006 14:51:08 I'm trying to help make it easy for our end-users to use SharePoint and Access together. By using the techniques in http://msdn.microsoft.com/library/default.asp?url=/library/en- us/dnsmart03/html/sa03i1.asp I've been able to programmatically link a table in Access to a SharePoint list - but that's not exactly what's needed. The problem is that an Access table linked to a List has no field set as a Primary Key. There is an ID field that is added to a custom list that is an AutoNumber field, but not a Primary Key. Because the Access table is linked, users can't go into the Access table's Design Mode and set that - and have the changes saved. I had hoped that creating an Access table with the same fields as the List, except with the ID field already set as a Primary Key - and then linking the two - would do the trick, but it's not working. Linking to a List seems to always generate a new table - the new table's name is the same as the one specified, but with a numeric suffix added. Anyone have any idea how to manually (or better, programmatically) edit the properties of a field in a linked Access table? Or for that matter, any insights into how to get SharePoint to make a linked Access table have the ID field be a Primary Key? Thanks in advance for any help on this! James