How To Link An Access Database to SharePoint

[@MrJarleth]

Many thanks for this. I have written a split Access2016 database for my organisation and we are moving to Microsoft 365 on Valentine's Day. Found this which is the answer to a prayer.

[@davsAlmanac]

Thank you? This may help me end my stupid process of turning forms into pictures and it's ridiculously time consuming a task that should be eliminated I got find the answer here. SQL is just a pain if I get the tables in I can't make forms with like over a hundred fields like I can in Access I would have to know code that's just to much for me. This a team meeting me myself and I. Just have to do this but backwards I will do this first then figure out how to do it backwards sounds like a plan the team has come to consensus the path around SQL is here like a blind man with a cane probing my way bumping into walls over and over I will maneuver the maze somehow someday I have to go turn my forms in Access in PDF then into pictures then process them upload them to my sites just to express the data in my forms this I call the process of stupidity. I just want to plaster this form on to the wall or page on my site someday I will figure out a way around my stupidity

[@charliearmour1628]

Thanks for this. I was under the impression that you couldn't link Access to Sharepoint - I read it somewhere. You have just proved otherwise. Again, thank you.

[@IZYSTUFF]

you CAN but its crap.

[@mubeenkhan5581]

@@IZYSTUFFHow can be crap can you please explain i am gona do this same by tomorrow.

[@joen2715]

After a year of using my sharepoint. I have upgraded my Access Design and revisited your video for instructions. I guess that I am less confused now, but you really made it simple to follow. MUCH APPRECIATED!!

[@charliearmour1628]

Thanks for this. Like others, I'd previously been told it was not possible to link Access to Sharepoint.

[@travelwiththainurse]

Thank you so much for your tutorial.

[@jaylanmannings7346]

I had to comment, this has help me so much.Keep being awesome.

[@microhandsltd]

Thanks for a very clear and concise video. It has helped me understand how things work with sharepoint

[@pikkabu2366]

Superbly presented... thanks

[@sarak4617]

Thank you for your video. I would like to share my database with my coworkers over SharePoint. I currently do not have the ability to create a site. If I have a split database and I put my back end file with my tables in a shared folder under Documents (in site library) can I give my users copies of the front end file to store on their desktops to all access the same back end tables at the same time?

[@JeffersonMartinSynfluent]

Would be interesting to see what the SharePoint list created for each table looks like as we would most likely carry out data backups from there.

[@ernestmokiwa4702]

Sure

[@TheHub047]

1. How to edit the tables on the SharePoint when needed? 2. Also, I hope adding a new table also the same way we added all the tables at first. 3. If we have Excel linked tabels then how to move it to SharePoint. And if the Excel linked tabels are updated by power query will that work in this case.

[@chankosol]

can we use multi-users at the same time?

[@GregOwenZA]

Yes

[@nicholasn8551]

@@GregOwenZA how ? because when i am tried to copy the file (front end) to another computer, the microsoft access, directly force close, crash

[@botanic904]

Thanks very much Sir.

[@deltarov5734]

Thank you for your video but I am having issues where for some reason MS ACCESS creates 3 fields in each of my tables called: "Title, Color Tag, Compliance". I have no idea why, it doesn't appear in my sharepoint list, I cannot delete them and is messes with the display of my forms. Does anyone know how to get rid of this?

[@garyprest4994]

Very useful, thank you

[@escyou1]

Excellent Advise. It works perfect!! Thanks very much!!

[@medoAlshehri1990]

Amazing many thanks, I have a database one of the tables is linked to an excel file how can I do the same process ?

[@stanTrX]

Thanks. Is it possible to secure your backend i think it is now the sharepoint tables in this demonstration? For instance they can add new data but cant delete or edit. Or maybe a method to make a backup for these tables but wait a sec. Maybe it has autobackup or revision history feature already as it will be a 365 product on cloud

[@stanTrX]

And also can we use our personal onedrive to host the lists instead of sharepoint site

[@leosnotstudying3143]

The tables are related ?

[@LoltreeGG]

amazingly helpful!

[@kaihusravnajmiddinov5413]

Very good. Thank you.

[@viniciodeluca1352]

Thank you so much, I could successfully upload after viewing a couple of times your video! Question: How do I modify my uploaded db? I suspect I must re-connect a local modified table? Any advice? Thanks!

[@tokerbb]

The forms need to be added by hand or can you share those as well?

[@HeyTezza]

Hi there, I have a table linked that has the attachment field. Do you know if I can get around having to supply login details each time I try to view an attachment?

[@alejandropocoroba1227]

Thanks for the video. I have a question: How can I add a new column in data from Access on my desktop, when I tried Access it told me "I need to edit the data from the source database, but I don't know where the source database is :(

[@spark339]

what area the limitations of the sharepoint lists? are the limited to only 2000 rows or records?

[@GregOwenZA]

2 gigs of data from what I understand

[@normanhazelhurst8613]

I can't get my attachments loaded on the SharePoint once I have noted people what do I need to do to correct this

[@ajrupani9471]

Thank you for this. How can I send a file where a new user can run it so I don’t have to manually link it on every single user?

[@zinmin6926]

Can delete back up file after share on site?

[@GregOwenZA]

Yes

[@beancount61]

I doubt this would work with my database. The _be file is about 1.2GB and the front end uses union queries and crosstab queries which I understand are forbidden in sharepoint.

[@shabbytv]

it wiil work because share point offers 1Tb of storage

[@OpeningEyes]

Can this work for the 5 dollar 1st plan on sharepoint? Or do I need full access?

[@nicholasn8551]

i tried on 1st plan sharepoint, and its success

[@mohammedallan6322]

Dear Sir. I do the same ur video, and the link is working. but I can't change the data on forms. you can help me

[@nicholasn8551]

hello sir, i have a problem with ms access, this the detail of my problem . 1. I have accdb 2010 file, and then i am tried to make this database online, so i tried split database. 2. The file_be, i am tried connect to sharepoint, and its success 3. The file_fe, i am delete the existing table, and get external data from sharepoint, and its success too 4. I am tried the application, its success, database on the sharepoint was update too, until this, i have no problem, but the problem is 5. I was copied File_fe to another computer, office 2010, and office 2013, and then when i am running the app, the application directly force close without information or warning, i have tried on 4 pc, and the problem was same, can you help me sir for my problem ?

[@joen2715]

Everytime I try to upload the backend file, it tells me there is an error copying data to a Sharepoint list. Duplicate output destination 'Title'.

[@smp9992]

SP adds some of it's own fields to each list. One of them is Title, so you need to rename your Title fieldname to something else

[@davsAlmanac]

My forms are odd I use forms to express data not to collect I use them more of a output the forms contain over 120 fields I never used templates or wizards the field each record in every table in a day every field is a calculation of a body stars asteroids planets moon sun many calculations I doubt if this would work with my forms I have no education in database design I did many things not meant to be done in access the migration of my forms into SQL this gives me hope

[@islammmi]

Amazing job

[@kosmasreth]

Greg how i can speak with you?

[@GregOwenZA]

How can I help?

[@andrechapman]

Thank you

[@mubeenkhan5581]

Does any one explain anybody tried recently ? i am gona do this same by tomorrow.

[@IZYSTUFF]

ok, that is good to know, and it works too, BUT if you over 5k rows, your sharepoint will fuck upp. Never seen such a slow thing. If you have that less data, then you dont need a sharepoint, so that sharepoint is pointing out itself. Nonsence, for less then 5k rows to set up a sharepoint. Also the update routine is crap, you have to delete all tables , update them local and load up new, like for less then 5k rows this is a process that costs too much time. This is a solution for a simple front end with almost zero recordsets.

[@shafa7668]

Tey