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

    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,613
    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 Advanced Beginner
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    86
    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 | Website

  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,613
    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 Advanced Beginner
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    86
    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 | Website

  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,613
    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

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 - Senior Forums