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...
Hi,
> Since this is a linked table I can't edit it in Access
That's true for many properties of a linked table but e.g. not for the Order By property. In Access
- open the table in design view
- delete the text in the property line
- click the Save icon before closing the linked table
Servus
Karl
*********
http://AccessDevCon.com
https://www.donkarl.com
Hi,
Funny. I had tried it successfully with an Order By setting for a linked Sharepoint list in Access 2010. Maybe it's different again with a newer Access version.
What happens if you do the Save As? Do you get a linked table/list with the changed property? In that case you could just rename it to replace the old one.
ServusKarl
*********
http://AccessDevCon.com
https://www.donkarl.com- No. It saves the linked table as a "Copy of" local table with no data in it. I think I am going to have to change the table to a local table, make the changes and then probably rename the SharePoint list to "_old" and create a new SharePoint list linked to the modified local table in Access.
