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

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.

Become a channel member to gain access to practice files and source code that I use in my videos.

Thanks for watching!

[marvinbrando]

This guy is something else. Total quality and advanced

[karldonaubauer]

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

[travisnull]

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.

[StetsonMgtSolutions]

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.

[alanhunold]

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

[bcapp]

Would an all Access solution (ie. not using Lists) located in Sharepoint be a good idea for a light use one-time project? I want to provide 5-7 colleagues with data entry forms to update certain columns in what is now an Excel file with about 30, 000 rows. They would be working on it at the same time. I'm new this and was thinking about having an Access back-end table for all the data and separate (identical) front-end Access Forms for each user for the data entry. Both the front and back-end would be in Sharepoint. Trying to keep it as simple as is reasonable. Appreciate your content!

[aniwenetv]

I am hooked, let me go see if this guy has a full course on Access DB from beginner to Professional (using and coding macros)

[stanTrX]

9:19 thanks, i like to do such lookup at the form level

[Jojosmith]

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

[Rhythm]

I have excitedly subscribed to the channel, and I look forward to your content... I have a question... Why do you refer to 'Tables' as 'Lists'? I don't understand what that is all about... Thanks

[GerryHoch]

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?

[RayaCurtis]

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?

[teboseema]

Thanks very informative. How would one upload a file in a SharePoint document library in access using a linked table to the document library

[bumpersmith]

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?

[aaronboydston]

When I export my access table to SharePoint, SP has a number column named "_OldID". Is that something to be concerned about?

[SchoonerMonaro]

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!