Forum Discussion
Edit Table Properties in Access Table linked to SharePoint List
I have an Access database with several tables linked to SharePoint lists. I recently removed some unused columns/fields from some of the lists. For one of the tables I get the following message ask...
I don't use SharePoint but you can right click on any linked table in the navigation pane and select Convert to Local Table.
BTW Is the first part of the connection string correct in the property sheet? ACEWSS?
BTW Is the first part of the connection string correct in the property sheet? ACEWSS?
As far as I know the ACEWSS entry (whatever that means) is correct. Everything is working fine. I just get the aggravating request when I try to open the table. I don't enter a parameter and click okay and the table opens just fine. All queries are working. I know you can make a linked table local. My question is, once I make it local, fix the Order By statement and save it, how do I relink the local table to the SharePoint list. If I remember correctly, trying to relink the table creates a new list in SharePoint.
