Welcome

I get asked all the time: "How can I share my Microsoft Access database with others online?" This seminar covers sharing your Microsoft Access database online using SharePoint. If you've got a small team and a small database, then a SharePoint solution might be right for you.

Resources

Topics Covered

What SharePoint is good for
What it's NOT good for
What YOU will need to get started
What your USERS will need
How to set up a SharePoint Site
Creating a SharePoint List (Table)

Sharing Your List and Setting up Permissions
Connecting Your Access DB to SharePoint
Linking to SharePoint Lists
Publishing Access Tables to SharePoint
Distributing Your Database to Other Users
How Non-Access Users can View/Edit Data

In Lesson 1, you will learn what SharePoint is good for, what it's NOT good for, and what both you and your users will need to get started using a SharePoint Access solution.

In Lesson 2, you will learn how to create your first SharePoint Site, how to create a new List (analogous to an Access Table), and how to enter and edit data using the SharePoint web interface.

In Lesson 3, you will learn how to connect Access to your SharePoint Site, how to log in, export your CustomerT table to a SharePoint List, and then link to that list form your database.

In Lesson 4, you will learn about permissions in SharePoint, how to distribute your database, giving other users access to your SharePoint List, sending email invites, and distributing an ACCDE encrypted Access file.

In Lesson 5, you will learn to see what user modified records in your database, the hidden table fields, and how to remove and change permissions.

Enroll Now

Enroll now so that you can watch these lessons, learn with us, post questions, and more.

Questions

Feel free to post your questions or comments below

Access Not Editing SharePoint Upload Images Link
Guillermo Baltazar
3 months ago

Hello! I split an Access Database where the back-end is a SharePoint List. The Access Front-end Form has a feature to locate a previously entered record and display the contents in the form. When I try to edit the contents of the form and then save / close, I receive the following message, Cannot update. Database or object is read-only.. What can I do to allow the SharePoint List to be updated?

After I click the OK Button, I get another error message, You cant save this record at this time. Program Strategy Form may have encountered an error while trying to save a record. If you close this object now, the data changes you made will be lost. Do you want to close the database object anyway?

I just click on the Yes Button to get out of that screen.

Alex Hedley
3 months ago

Can you edit it directly in the Table?