In this article we look at salient aspects related to deploying an Access database on a SharePoint Server
MS Access is one of those applications that can support multiple simultaneous users. It often happens that those users; apart from using MS Access, also need to make use of other applications, which often need to be shared among several users. Although this has been something that could not be done well using Access for a long time, this has changed since the users have been able to deploy MS Access over SharePoint. This is one of the best platforms for Access users, who are looking for a more suitable platform for their databases. Through the deployment, you will get access to features which are truly tremendous, and don’t even require to be installed. The best part about it, is the ease of use, you do not have to be a SharePoint expert for Access on SharePoint, all you need is a URL to SharePoint Server and permissions for creating sites on the server.
Deploying MS Access on a SharePoint Server
To promote SharePoint server as the best platform for deploying your MS Access databases, Microsoft has allowed for more than one way to do it. The first one is by; exporting the table, the second way is enhanced exporting, and the third one is by publishing data on SharePoint. Here we will be discussing about the third method, which involves publishing Access applications in SharePoint. However, before that, we will have a look at the steps used for deploying MS Access in SharePoint, which will make all Access users authorized for accessing the application across SharePoint.
- Go to SharePoint and open Shared Documents Library. Now select ‘Add New Document Link’. The Upload Document dialog box will appear, using this you can add complete Access databases files too.
- Select the Access database file by browsing, and then import the file to SharePoint.
- The database entry will now appear in the Shared Document List, double click on it, to open it.
The open document dialog box will appear on SharePoint, and you will find your Access application ready for use on the desktop.
Publishing in SharePoint
This will enable the user to use all the Access application objects from within SharePoint, and all users with sufficient SharePoint credentials, will be able to access it using a web browser. Without requiring Access runtime on the desktop of the user. The developer will always have a copy of MS Access on their database, the master copy however, will be on SharePoint. The developer will be able to make changes to MS Access application anytime, and then sync them with the application published on SharePoint. While an Access deployment on a SharePoint server is quite stable, it still helps to keep a tool to recover from Access damage for contingencies.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair SQL Server and excel recovery software products. For more information visit www.datanumen.com