Creating and Linking to SharePoint Lists from MS Access | Access + SharePoint Development - Pt 1 

Thank you my friend! I'm glad you're finding the videos useful. I will definitely make some more material on that topic. If you would like to see a specific type of example, let me know. Take care!

Hi Karl, thanks for checking out my video and for the great tips!

I agree. Unless you need a web interface, I would definitely go with Access.

Thanks for the positive feedback and thanks for checking it out!

Thank you, Jojo, for that awesome encouragement my friend. It means a lot!

So do I, definitely my preferred method. Thanks for watching my video!

I have the same questions. thanks for asking

Thanks so much for that kind feedback and for your question. Once you have your linked tables established in Access (pointing to your SharePoint lists) you will be able to perform all Create, Read, Update, and Delete transactions on the data right inside the Access front end. The only thing you cannot modify from Access is the table design. So, like adding a new field to the table / SharePoint list, changing the data type of a field, increasing the number of characters a field will hold, changing the data format... that would all need to be done on the SharePoint site. I'll make a short video on this topic on Friday and give you a more solid example of what I mean.

Hi Jojo, please see my reply to Gerry's comment. I will make a video on this topic Friday to give you a better example of how this works. Thanks!

Thank you so much Rick for your quick update and reply. Rick is the BEST. Love your tutorials very useful. Thanks millions for your precious time@@advantageapplications5712

@@advantageapplications5712 Thank you for your quick reply. I do have one more question. How do the linked tables work with images? If I were to add an image in access to one of the linked tables, would the image transfer to the Sharepoint list?

Hi BumberSmith, and thanks for checking out my video. I will be covering that very topic, either in this series, or in the near future. The good news is that it can be done and I currently store images in SharePoint lists for the "bolt-on" PowerApp I quickly show near the end of this video. I'll take you through that same process in my upcoming video. Take care, my friend!

Thank you for the very kind feedback! I hope to put that video out by the end of May. Work has really ramped up with a couple new projects I've started but I am still plugging along in making video content, just slowly. hahaha Take care, my friend!

No, I get those in some of my exports as well. As long as your primary key field is auto-incrementing as it should (if it was an auto-number field when it was in Access, of course) and the other fields you specified in your table design in Access are correct then you should be good to go.