With Access 2013, you can create a database system on your local computer, move it to the cloud, and make it available to all of your customers, prospects, employees, or other stakeholders. Hundreds of people can access your web app at the same time. They can use their desktop or laptop PC, their tablet, and even some smartphones to interact with your web app.
Can you simply move the Access database that you’ve designed on your desktop computer to your web server and call it a web app? No. It’s quite a bit more complicated than that.
First, you have to make sure that you’re using the subset of Access features that are supported in web apps. Most features are supported.
But the missing pieces are big. You can’t use any Visual Basic (VB) code in your web apps. You can’t use reports. And if you’ve customized any Access forms, they won’t work in a web app.
Second, you have to run your web apps on a SharePoint 2013 server. There are three ways that you can do this:
(1) Use Microsoft Office 365
Microsoft launched Office 365 in June of 2011. Office 365 is a subscription-based version of Microsoft Office that lets you run Word, Access, Excel, and other programs in the cloud. The least expensive versions of Office 365 don’t support SharePoint, so you can’t use them for your web app. Each person who will be reviewing and maintaining data for your web app will need their own subscription to Office 365.
(2) Use your company’s SharePoint 2013 server
Chances are, your company doesn’t have a SharePoint 2013 server.
SharePoint servers are expensive to license, and complicated to maintain. You’re out of luck if your company has the free SharePoint Foundation 2013 server; it won’t be able to host your web app.
Typically, only the largest companies can afford to license and support a SharePoint 2013 server.
(3) Find a third-party SharePoint hosting company
While it can be expensive to work with a third-party SharePoint hosting company, for most companies this alternative is the only one that is viable. A firm that offers SharePoint hosting to a wide range of customers can afford to hire a top-notch manager to keep the server running properly.
Another requirement for hosting a web app is the availability of SQL Server, a relational database management system from Microsoft. Don’t let the idea of working with a complex system like SQL Server frighten you. SharePoint and Access handle all of the technical SQL Server overhead, so you get all of the benefits of a powerful database management system, with no additional technical work required.
The Access application includes almost everything that you need to create your web app. You will have to use a SharePoint 2013 server. And, of course, you should always have Access recovery software installed on your computer so that you can identify and repair Access databases that have been damaged. Learn more about DataNumen Access Repair on https://www.datanumen.com/access-repair/.
Alan Chen is President and Chairman of DataNumen, Inc., whose data recovery technologies include Access repair, SQL recovery software products, and more than 20 other software recovery applications. For more information about the DataNumen line of data repair and recovery applications, visit www.datanumen.com