Results 1 to 3 of 3
  1. #1
    ExtremeNovice is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    24

    My my database tables are on SharePoint as lists, now how do I distribute my front end?


    I'm relatively new to all this so forgive the stupid questions...
    I have built my database and got my tables on SharePoint as lists, what is the best way to distribute the front end to the intended users? I am having trouble getting an multi-user set up working and have not been able to find a how-to guide on deploying the front end for multi-user environment. Currently only one user can have the file open with anyone else being locked out. Do I need to create user profiles? (if so, how?) Do I need to look over my SharePoint settings? Or, do I need to adjust my security or client settings?
    I had everything working just fine as a split database over a shared network but I run into all kinds of problems when the tables are on SharePoint.
    Any resources would be greatly appreciated.

  2. #2
    ExtremeNovice is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    24
    The answer was to save it as a .accde file type, then distributing copies of that file to the users (once the file is at its destination, the user's desktop for example, you also have to go into the trust center to make sure that is set up right). Pretty simple.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks for sharing your success and solution.

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

Similar Threads

  1. Number format in tables stored on Sharepoint as lists
    By tim.cassey in forum SharePoint
    Replies: 0
    Last Post: 02-16-2016, 08:08 PM
  2. Help actually using Linked Lists with SharePoint
    By NathanBurley in forum SharePoint
    Replies: 8
    Last Post: 08-07-2015, 12:50 PM
  3. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  4. Synchronize Sharepoint Lists
    By jerem in forum SharePoint
    Replies: 7
    Last Post: 07-15-2014, 10:54 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