If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services.
If you don't already have a database, you can quickly create one from a template. In Access 2010, click File, New and Sample templates:
I selected an Issues Web Database:
Once you've made your choice, click the Create button:
If you like, you can enter any data you need to get your database started or do this once it's shared - your choice. When you're ready to share it, click File, Save & Publish, and Publish to Access Services:
On the right side of the pane, enter the Server URL to your SharePoint Team Site:
When you've confirmed the Server URL, click the Publish to Access Services button.
To find your database, go to your SharePoint Team Site and click View All Site Content:
Scroll down to the Sites and Workspaces section to find your database:
Click the link to access it and then click Options to manage permissions and share with colleagues:
Nice post. Here’s how you can move or convert Microsoft Access to web in minutes
I would like to know what is a sharepoint. For example when I do not have access to the server which sharepoint I can use?
Please help me with this bcause i' ve tried using 'http://localhost' and failed.
Access 2010 really has come a long way. I'm so glad I stuck with it.
Paul Harrold <a href="http://www.comcraft.co.uk">Microsoft Access database developer</a>
Is it possible to publish an access database from several different SharePoint sites? Currently using WSS 3.0 but due to upgrade in a few months.