I have had a SharePoint list set up as a linked table in Access for several months. Whenever I needed to add a field to the SharePoint list, I deleted the linked table in Access and re-linked it. Always worked fine. However, now when I try to add a new field to the SharePoint list, after re-linking in Access, the data for the ID field in the SharePoint list appears in the new field. When I examine the properties, the new field is also showing as the key.
Any Ideas?
Thanks,
Jeff