If you have Office 365 and Sharepoint (SP), you can create online SP Lists for your shared online data, then link the lists to MS Access. All users can use Access and see all online data for reports, etc. If you were to make PowerApps, you can use the lists from phones or tablets as well.
Does microsoft access work on sharepoint?
Access 2010 and Access Services provide a platform for you to create databases that you can use on a Share, and point site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the Share. Point site use the web database in a web browser.
However, they are part of the web database and can be used in Access 2010 on the desktop. People can open the web database in Access, and then use the client objects. This is an effective way to share a database, and also opens new opportunities for working together over the Web., share Point handles any concurrency issues.
Can I use access 2010 with SharePoint Web databases?
Less Important Microsoft no longer recommends creating and using Access 2010 web databases. For more information, see Access 2010 web databases roadmap. You can use Access 2010 and Access Services on Share. Point to build web database applications. This helps you: Secure and manage access to your data.
Can I publish Access 2010 reports to SharePoint?
Although Access 2010 reports can be successfully published to Access Services on Share. Point, they won’t run in the browser when you publish them to Microsoft 365. We recommend opening the database in Access to view reports, and using forms or datasheets to format data for printing in an Microsoft 365 environment.
How to access Microsoft SharePoint from your desktop?
Select the blue One. Drive cloud icon in the Windows taskbar notification area. To see a list of all your syncing sites, select the Account tab. To change the folders that you’re syncing, select Choose folders for that library, and then select the folders that you want to sync.
How to import /export access database to SharePoint?
Use the DSN within an Access desktop database to import the Access web app tables. Create a new Access desktop database or open an existing Access desktop database. On the ribbon, click External Data > ODBC Database within the Import & Link group. On the Get External Data – ODBC Database dialog box, select Import the source data into a new table in the current database and then click OK., and more items.
To add a content database to a web application by using Central Administration. Verify that the user account that is performing this operation is a member of the Farm Administrators Share, and point group. On the Share. Point Central Administration website, click Application Management. In the Databases section, click Manage content databases., and more items.