Sep 20 2022 07:33 AM
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 information through forms and my goal is to consolidate their answers in a single database
Sep 20 2022 08:07 AM
Sep 20 2022 08:21 AM
Sep 20 2022 10:10 AM
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
Sep 20 2022 12:11 PM - edited Sep 20 2022 12:12 PM
I read the question a little differently.
You can't share the interface elements of an accdb online in the sense most people probably think of.
Access runs on the desktop, so you won't put Access forms directly into the browser.
That said, there are ways to make the DATA available to a browser-based interface, which would need to be built for that purpose.
SharePoint itself is not an option. Access accdbs are not designed to work properly when run from SharePoint, but as Karl pointed out, you can migrate the data to SharePoint to share the data that way.
Probably experienced Access developers prefer the other approach Karl suggested, SQL Azure or a hosted SQL Server.
Depending on the number of users and volume of data, and how much your organization is willing to invest in an online solution, there are several ways to deploy an interface for the online environment. You can always deploy the Access FE to users so they can put it on their own computer and connect to your data in "the cloud".