Results 1 to 11 of 11
  1. #1
    louise is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Apr 2015
    Posts
    112

    How to get Backend to Sharepoint so can link to its tables


    Hello,
    I am working with Business 365, Sharepoint and Access.
    I have split my database, and plan to distribute the Front End to our users, so that they can enter data and run reports, etc. through their Access software -- using links to tables that are on our SharePoint site.

    But I can't figure out how to get my Back End to the Sharepoint site so that it is available for me to link to.

    Also, I saved it to my pc for the moment, but is there a way that I can put the Back End on to the Sharepoint site as part of the splitting process?

    (I would prefer to not have to convert my tables to SharePoint lists.)
    (My understand that this is something different than just "storing" the backend there for backup purposes.)

    Thanks for any help!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,718
    I don't have experience with Sharepoint, but I recently saw this presentation by Albert Kallal which may offer some insight.
    Good luck.

  3. #3
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Quote Originally Posted by orange View Post
    I don't have experience with Sharepoint, but I recently saw this presentation by Albert Kallal which may offer some insight.
    Good luck.
    Very helpful @orange, I'm busy watching this at the moment.
    @louise, skip to 25 minutes +-
    Greg Owen
    Owen Media
    owenmedia.co.za

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,718
    Happy to help. If his material is helpful and you can move/use sharepoint as easy as Albert says, please tell us about your experience. It may help others.
    Good luck.

  5. #5
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    It was very helpful, however, I could make a video that addresses how to do this in 5 easy minutes. Will it be okay if I make a recording and upload a link here?

    @louise, the SharePoint lists is the backend table storage, there's nothing to worry about. I've literally just finished doing a test for a very small Human Resources database of mine of the employees at our business which has proved to work well as I can access it via the FE access file on my PC here and another 40 mi away using a FE on that machine with synchronised data! This is incredible! I just need to figure out how to store files through an upload feature to the SharePoint site to store PDF's that can be called through a "Documents" tab on demand.
    Greg Owen
    Owen Media
    owenmedia.co.za

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,718
    I say Go for it. If it can't be stored here, then store it on you favourite location and post link here.
    I'm sure it would be helpful to those interacting with Sharepoint.
    Good luck

  7. #7
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Hello orange, I managed to make the video in 10 minutes, 5 minutes was a bit to optimistic here's the video I made on how to link an Access front-end to a hosted SharePoint back-end data.

    https://www.youtube.com/watch?v=b2bb_3Wg80g
    Greg Owen
    Owen Media
    owenmedia.co.za

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,718
    Good stuff Greg! I just watched the video.Voice is good, quality is good and has close captioning. I'm sure it will be helpful to Access/Sharepoint developers/followers.
    Looking forward to new discoveries/learning.
    Thanks for posting.

  9. #9
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    That’s a pleasure. Disclaimer: it’s best to first develop your database within Access normally before trying to reconfigure your tables on SharePoint. The naming of the data fields seem to change and the structure too, however, if you develop your database normally within Access, test it, then upload your working backend to SharePoint you don’t have any issues. I’ll try create a more advanced video soon but I think this hits the basics and does work.
    Greg Owen
    Owen Media
    owenmedia.co.za

  10. #10
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,291
    Quote Originally Posted by Blings View Post
    Hello orange, I managed to make the video in 10 minutes, 5 minutes was a bit to optimistic here's the video I made on how to link an Access front-end to a hosted SharePoint back-end data.

    https://www.youtube.com/watch?v=b2bb_3Wg80g
    Nice video Greg
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  11. #11
    kd2017 is online now Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    904
    Quote Originally Posted by Blings View Post
    Hello orange, I managed to make the video in 10 minutes, 5 minutes was a bit to optimistic here's the video I made on how to link an Access front-end to a hosted SharePoint back-end data.

    https://www.youtube.com/watch?v=b2bb_3Wg80g
    Good work! I'm going to look into this further.

    I hope that wasn't Sarah's real info though 😬

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 06-19-2019, 08:51 AM
  2. Replies: 3
    Last Post: 07-04-2017, 08:04 AM
  3. Storing backend db on SharePoint Library?
    By lilvictorians in forum SharePoint
    Replies: 0
    Last Post: 06-30-2016, 07:45 PM
  4. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  5. Sharepoint Lists vs Web database as backend
    By is49460 in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums