Results 1 to 3 of 3

Front end Access on Sharepoint - Back end SQL Server

  1. #1
    craig1988 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    82

    Front end Access on Sharepoint - Back end SQL Server


    Hi all

    I have been working with access for a while now and I am fully comfortable with splitting frontend and backend. Now I would like to explore the possibility of hosting the front end on internal (company) SharePoint and the back end on SQL server.

    Is it possible?
    Limitations?
    Is it easy to do with an existing DB

    Thanks
    Craig

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,332
    I've no idea whether it is possible, but with just the physical issues my guess would be you run the risk of corruption, it would be very slow and probably not enabled for multi user. And why would you want to host the front end on sharepoint? what do you see as the benefit other than maintaining a master copy in a central location?

    But it would be easy to test. Just copy your front end to sharepoint and try to open it.

  3. #3
    AdrianG001 is offline Novice
    Windows 10 Access 2007
    Join Date
    Mar 2018
    Posts
    9
    Refer the below guide from microsoft
    docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-create-external-content-types-for-sql-server-in-sharepoint

    Adrian Gates
    Sr. Cloud Expert - Apps4Rent

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

Similar Threads

  1. Replies: 1
    Last Post: 05-11-2016, 08:14 AM
  2. Replies: 4
    Last Post: 04-14-2015, 12:51 PM
  3. Replies: 4
    Last Post: 10-03-2014, 11:57 AM
  4. Replies: 4
    Last Post: 11-29-2012, 12:45 AM
  5. Using Access as Front End for SQL Server
    By workinstiff in forum Access
    Replies: 4
    Last Post: 07-18-2012, 12:16 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
  •  
Tech Forums: Microsoft Office Forums