SharePoint/Access question regarding linked tables

gunbunnysoulja

If I have an Access (2007) table that is linked to a SharePoint (2010) list, and I need to constantly update the Access database with new table information from a different database/table, what would be the best method to do this to retain the SharePoint list connection?

Xcluziv

I haven't used Access Services to much since I have been working with SharePoint and I know most people would probably use Excel Services to get the functionality that you desire, but here is something you can try

To start the wizard (in Access), Click the External Data Tab->Click the SharePoint List icon in the group->Then
you are required to enter the URL of the SharePoint site and indicate whether you would like to import the list data or create a link.

In this case:

Enter the full URL to your SharePoint Site, Click the Link to the Data Source by creating a linked table ->Then
next, select the list required, click OK.

Also note the new item in the Access 2007 status bar located in the bottom right corner->Clicking the button opens a context menu that will permit you to:

Cache the List data locally, Work Offline.
If you choose to Work Offline, the online link between Access and the SharePoint list is removed with your data now existing independently in Access
Note how the linked list icon changes to reflect the status of the list.

Now that the list is offline:

Open the list -> Add a new Record using Access.
Once you have added the new record you will need to synchronize the changes to SharePoint:

On the Status bar click the button titled Offline with SharePoint ->Select Synchronize.

Access will now update the SharePoint list with your new records!

gunbunnysoulja

Thanks for the information. I should have clarified, but I have that aspect working. The customer pulls data from a remote database that has updated table values. I think it's going to be a matter of running a query from the new table to import to the linked SP table so it can reflect the new changes. This way SharePoint doesn't keep creating new lists, as SharePoint doesn't overwrite old ones, or else I would just link the new table to SP.