Creating and Linking to SharePoint Lists from MS Access | Access + SharePoint Development - Pt 1
ฝัง
- เผยแพร่เมื่อ 2 ส.ค. 2024
- In part 1 of this video series, we look at how to create tables that will ultimately become SharePoint lists as well as the advantages of using SharePoint as a backend for solutions built in Microsoft Access. We'll also cover how you can extend your Access / SharePoint solution with Power Automate, Power BI, and Power Apps.
In pt 2 of this series, we'll discuss how to re-establish relationships between tables linked to SharePoint lists.
• Relationships, Queries...
Become a channel member to gain access to practice files and source code that I use in my videos.
www.buymeacoffee.com/advantag...
Thanks for watching! - แนวปฏิบัติและการใช้ชีวิต
![[ไฮไลต์] แบดมินตันชาย SHI Yu Qi (จีน) vs วิว กุลวุฒิ (ไทย) รอบ 8 คน | โอลิมปิก 2024](http://i.ytimg.com/vi/f7z7taforOM/mqdefault.jpg)
Hi Rich, good video. Just a few additions:
1. Alternatively, exporting to and linking from Sharepoint can also be done in 1 step with ribbon: Database Tools - Move Data - Sharepoint
2. Alternatively, you can also create new fields for linked Sharepoint lists directly in Access, as well as change existing fields. To do this, go to the datasheet view of the table and select the "Fields" tab in the ribbon.
3. After a list design change in Sharepoint, the list does not have to be deleted and relinked in Access. It is sufficient to right-click on the table in the navigation pane and from the context menu select: More Options - Update List
Hi Karl, thanks for checking out my video and for the great tips!
Sharepoint is a new level for me, as I have only worked on stand alone DB’s with linked tables on an internal network. I am working sandbox solutions currently and enjoying your presentations.
Thanks for checking out my channel and for the kind feedback! I'm still getting my bearings as a video creator, so I appreciate it. If there are any topics you would like to see me cover, or take a deeper dive into, please let me know. Take care!
I could use some of the instruction you referred to at 21:00 , regarding the row source controls. I'm loving your videos as I learn more about this so I can build a database for my fuel transport company.
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!
Really good content, thanks!
Thanks for the positive feedback and thanks for checking it out!
I’m a total beginner when it comes to access.
I do have experience programming in languages like PHP and JavaScript tho, so some concepts are transferable.
I have many spreadsheets that I manage and they have related data between them so access just makes sense short of building a complete web app which comes with a whole new set of problems within itself
I agree. Unless you need a web interface, I would definitely go with Access.
all thumbs up to another Rick's excellent videos. Already subscribed, hope the others do too. Looking forward to more. thanks a lot Rick for sharing your knowledge
Thank you, Jojo, for that awesome encouragement my friend. It means a lot!
9:19 thanks, i like to do such lookup at the form level
So do I, definitely my preferred method. Thanks for watching my video!
Thanks very informative. How would one upload a file in a SharePoint document library in access using a linked table to the document library
Hi Rich - great video. Once I have created the database, synced to SharePoint, then reconnected an Access front end, can I connect other Access front ends that are all linked to the same SharePoint back end? Talking a total of 3 users max, would we have issues if multiple people are working in an access front end at the same time?
Hi Ray, and thanks so much for checking out my video. Yes, you can definitely link other front-end Access files to the same SharePoint lists. In fact, that's one of the best parts about having your data on SharePoint instead of Access. One of the solutions I developed, and support literally has over 200 users all linked to the same SharePoint backend. They aren't all in there at the same time, but there are always several concurrent users.
I hope that answers your questions. Take care!
Love the video and great explanation. Newbie question... once the tables have been re-established from Sharepoint, can you make changes and/or edit any of the data in Access? Or do the edits need to be made in Sharepoint?
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?
I have the same question as @GerryHoch concerning photos. I have an Access application about genealogy that includes many photo and document attachments about individuals and families. How would this type of situation be handled with SharePoint lists as far as storing the photos and documents?
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!
11:30 Wow, this explains my current problem. I'm migrating the tables from an existing database to Sharepoint and have noted a number of data errors in the result. I tried removing relationships before migrating, but they still occurred. Thank you for pointing out that Sharepoint is renumbering the key - it is obvious now I know it. I'm looking forward to your video on the process and tools you have developed for migrating an existing database.
Very useful set of videos. Access still has a lot of advantages and I really like the combination of Access and Sharepoint Lists.
Thank you from Australia!
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!
When I export my access table to SharePoint, SP has a number column named "_OldID". Is that something to be concerned about?
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.