Forum Discussion
How to Share MS Access forms Online
Hello! I am new to MS Access, and I have already built my tables and forms. However, I am having difficulties on how I can share the forms with the end user. My goal is to have them enter inf...
MS-Access form can not published to web. You have two way. (1) Share your database to sharepoint so other user can update it. (2) You can use Azure cloud SQL database as backend and MS-Access as front end. Then user can enter data from anywhere connected to internet.
- Do you know any documentation that I can look for these 2 option? Thank you! I appreciate your response.
Hi,
The Sharepoint wizard is included in Access:
Import, link, or move data to SharePoint
Migrating the data to SQL Azure is more complex. Most people use SQL Server Migration Assistant for Access (SSMA) and migrate the Access data first to a local SQL Server, optimize it using SQL Server Management Studio (SSMS), and then migrate it to Azure SQL. But SSMA can also do it in one step. You can find some documentation if you click through the menu tree on the left side of the above linked page.
Servus
Karl
Access News
Access DevCon
