How to migrate an Access database to SharePoint
HTML-код
- Опубликовано: 19 окт 2024
- This video is the last in my series on solutions built in Microsoft Access linked to SharePoint. In this video I show you how to migrate a database that has already been in use in Access, out to SharePoint using a custom tool that I built over the years to help streamline the process and help ensure that it's done right.
If you would like a copy of the SharePoint Migration Tool, please visit the link below:
buymeacoffee.c...
Thanks for watching!!
Hi thanks for the videos, appreciate it.
I’m wondering when you move the tables to SharePoint and use Access as front end, does the Application convert into a Client Server environment? Meaning does SharePoint imports the tables into a SQL Server in the background.
Reason I’m asking this question is because I want to know if say 30-50 users can use the app vs 5-10 Access can normally do (assuming db is split is done correctly).
Thanks
Excellent question, and the answer is yes... which greatly improves the usability of your Access application and is one of the primary reasons for building (or migrating) solutions so that the data resides on SharePoint. I have an event notification system in place with a large chemical company and it supports upwards of 20 concurrent users at any given time.
After creating the Access front end with tables linked to Sharepoint, can I simply copy that front end file onto other user's workstations in the company? Do users need to be logged into their 365 and would I have to setup shared permissions on the sharepoint URL? In other words, anyone can't just open this front end file on any computer and expect it to work, correct? Thank you for your help!
Hello! Yes, once the linked tables are established, the front-end file can be distributed to your users and, as long as they are logged into Office 365 and their accounts have permission to access the SharePoint site where the lists reside, they will be able to use the front-end file without issue.
Thanks for watching my video!
Before asking "How" you shall ask "Why"
ruclips.net/video/y6KKQtjdlek/видео.htmlsi=3pJB8DF6goTBDaU8