RichardMGreen
Well-known Member
- Joined
- Feb 20, 2006
- Messages
- 2,177
Hi all
We've got various SharePoint lists for pieces of work being actively worked on and I want to link to ours in Access 2016 (.accdb format) to save using the web interface and keep all our stuff in one place (we use the same Access database for other things).
I've linked the list to Access using the wizard but it comes up as disconnected even though it's a linked table and won't let me reconnect due to "network issues".
I can edit the list and add items (which is what we want to do) but it doesn't save back to the SharePoint list (probably because it's disconnected).
I haven't tried importing the list as I need the updates that we enter onto the the database to be reflected on the SharePoint list.
I've followed this link https://support.office.com/en-us/ar...int-list-65bf7b03-74bf-445c-959a-24b7a401ddee to make sure I'm not doing anything dim but it's still not working.
Anyone any ideas where I'm going wrong?
We've got various SharePoint lists for pieces of work being actively worked on and I want to link to ours in Access 2016 (.accdb format) to save using the web interface and keep all our stuff in one place (we use the same Access database for other things).
I've linked the list to Access using the wizard but it comes up as disconnected even though it's a linked table and won't let me reconnect due to "network issues".
I can edit the list and add items (which is what we want to do) but it doesn't save back to the SharePoint list (probably because it's disconnected).
I haven't tried importing the list as I need the updates that we enter onto the the database to be reflected on the SharePoint list.
I've followed this link https://support.office.com/en-us/ar...int-list-65bf7b03-74bf-445c-959a-24b7a401ddee to make sure I'm not doing anything dim but it's still not working.
Anyone any ideas where I'm going wrong?
