Wants to share your access database over the network for multi-user access? Well there are so many ways to share such but moreover it depends on user’s need and resources available to them.
So, let’s start our journey to grab knowledge on the ways to share up the Access database.
So, let’s start our journey to grab knowledge on the ways to share up the Access database.
3 Ways To Share Access Database On Network
Here are the 3 most easiest way to share up your Access Database. Let’s discuss them briefly:
- Split Database
- Share Data By Using Network Folders
- Share a database by linking to SharePoint lists
- Split Database
If you don’t have SharePoint site or other database server to share the access database then spilt database is the perfect option to share up your access database. In this method of sharing the database, the database is get splited into two parts i.e front end and back end. Back end database file contain data tables whereas the front end contains the access database objects like forms, queries, reports, etc.
When data is shared every user will get a copy of the front end database. Use the split database wizard to split the Access Database.
- Share Data By Using Network Folders
The second option is sharing the Access Database using a network folder. This method is less recommended because it is less secure than other. As in this each user has a complete copy of the database and this will raise the risk of unauthorized access. This method has limitations like, at the same time only few users can use the database.
Simple Steps to share a database by using a network folder
- Set-up a shared network folder.
- Open the Access Database in shared mode for all users’ access.
- User must have read/write permission to access database. Copy database file to shared folder.
- You will see that short-cut of the database file is get created on user’s system.
- Sharing MS Access Database on a Sharepoint Site
In order to share database on sharepoint, Windows Sharepoint services must be running on the server. Sharepoint feature is quiet helpful to access an application from different location which makes the data available for users through web browser.
This can be done in two ways either by publishing Access database or by shifting the tables to sharepoint lists and then link it with ms access database. By moving tables to lists each user is able to make changes in their copy of the database. Where as, the feature of multiple-user modifications in the database is not available while publishing the Access Database.
Conclusion:
You can try any of these options to share your access database as per your need.