How to Publish a Microsoft Access Database

by Ashley Leonard

Microsoft Access is used to create forms and databases that can record information and improve productivity. Once you create a database, you have the opportunity to publish it so individuals can see your work. Publishing a Microsoft Access database might seem daunting but it can be doneeasily.

1

Click "Start" on the lower, left corner of your screen and select "All Programs." A menu will open. Click "Microsoft Access." The program will open. Open the database that you want published.

2

Click on the Microsoft Office button on the upper, left corner of the page. Select "Publish" and click "Document Management Server." A new window will open, allowing you to begin publishing your database.

3

Type the URL of the Sharepoint site where you want the Microsoft Access database published. A Sharepoint site is a Windows-created server that allows you to upload databases and other forms. Your Microsoft Access program should allow you to create a Sharepoint site if you are using it for the first time. When you publish a database onto a Sharepoint site for the first time, Access will provide a list of servers that will make it easier to go to the location where you want it published. Access will remember the location for future publishing.

4

Select the library where you want the database published. Click "Open." In the "Name" box, on the left side of the window, type in the file name for your database. Click "Publish" to publish your Microsoft Access database.

Tip

  • check When you open your Microsoft Access database on your Sharepoint site, you will be prompted to save a copy.

Items you will need

About the Author

Based in New Jersey, Ashley Leonard has been writing professionally since 2007. Her articles have appeared on rsportscars.com and various other websites. Leonard holds a Bachelor of Arts in communications from Marymount Manhattan College.

Photo Credits

  • photo_camera computer image by Ewe Degiampietro from Fotolia.com