How does SharePoint Sync Access database?

Question

You can synchronize the data in a SharePoint list with Access 2010 by using the Open with Access command in the list ribbon. This command creates an Access .

Can you link an Access database to SharePoint?

A linked SharePoint list or Access database updates both ways. On the External Data tab, select the type of data you want to link to (Excel, Access, Text File, XML file, or HTML file). Select Browse, select a file, and then select Open.

How do you sync an Access table to a SharePoint list?

In the ribbon, click the List tab, and then in the Connect & Export group, click Open with Access. Specify a location for the new or existing database, or click Browse to locate a database. Select Link to data on the SharePoint site, and then click OK. Note: You can also click Export a copy of the data.

How do I move an Access database to SharePoint?

To migrate the Access tables to SharePoint lists, within Access --> Export / More / SharePoint list. None of the other objects are migrated to SharePoint, so if you want to continue using the objects, they would stay within the Access database, and you would base these objects on the lists linked from SharePoint.

Is SharePoint good for database?

Although SharePoint rests on a database management system and has some similar functionality, the platform itself is not a database. If all you need is just structured and secure storage for several thousands of documents, SharePoint can easily meet your needs.

Expert · Answer