How to Share a Microsoft Access Database
Databases are an essential part of the business world, but many database programs are difficult to use and even harder to learn. Microsoft Access is an exception to this rule--this powerful database program is easy enough for even a beginner to use. Network administrators and programmers can set up a database and share it among all of the users who need to access it.
Other People Are Reading
Instructions
-
-
1
Create the database you want to share. Make sure you create a user-friendly data entry form, especially if the people who will be using the database are not tech savvy. The fastest way to create a data entry form is to open Microsoft Access, click on the "Forms" tab and choose "Create Form by Using Wizard." From there you can choose the table on which the form will be based and have Access automatically create the data entry form workers will use.
-
2
Set up a shared space on your home or company network. Decide which users need access to that shared folder, and grant each of those users access. To create a new folder on your network, highlight your network drive, right-click and choose "New" from the menu, then choose "Folder." Give the folder a descriptive name like "Access Share," and press the "Enter" key. Then right-click on the new folder, choose "Properties" and select the "Sharing" tab. Select the users who need access to the share.
-
-
3
Save your Access database to the network share drive you have created. If the database is currently on your hard drive, you can move it by right-clicking on "My Computer," choosing "Explore" from the menu, highlighting the file and clicking "Copy." Then go to the network share drive and click "Paste."
-
4
Create a desktop shortcut for each user who needs to access the database. Right-click on the desktop, choose "New" from the menu, and then click "Shortcut." Click the "Browse" button, navigate to the network share, and highlight the database you created. Have each user double-click on the new shortcut to make sure they can access the file.
-
1
