Results 1 to 3 of 3
  1. #1
    sberti is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Nov 2012
    Posts
    33

    Issues with Back End in SharePoint

    We have a db that is accessed by multiple users.


    I originally split the database and uploaded the tables to SharePoint lists. The db ran slow, but was useable. As time has progressed, with more data being added weekly, it began to run slower and slower and some of the filters in our forms stopped working.

    When I made a copy and converted the tables to "local", everything works fine. So my next solution was to upload the Back End, not as SharePoint Lists, but as the Back End Access file.

    The performance is fine, but SharePoint keeps automatically creating duplicates of the Back End file as multiple users use it.

    Does anyone have any solution for this. I'm ready to give up on SharePoint for our Access db and look into either a Server that everyone accesses by Remote Desktop or I need to learn more about Microsoft Azure.

    If anyone has suggestions, I would appreciate the input.

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    Here's a link to my same question.
    https://www.accessforums.net/showthread.php?t=57598

  3. #3
    sberti is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Nov 2012
    Posts
    33
    Thanks for the reply.

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

Similar Threads

  1. Replies: 0
    Last Post: 03-24-2014, 09:35 AM
  2. Compatibility issues with db for Sharepoint
    By maxmaggot in forum SharePoint
    Replies: 4
    Last Post: 07-23-2013, 12:10 PM
  3. Move to SharePoint Site issues
    By Mercator in forum SharePoint
    Replies: 4
    Last Post: 12-27-2012, 05:52 PM
  4. Issues Web Database in Sharepoint
    By abriscoe in forum SharePoint
    Replies: 6
    Last Post: 05-31-2012, 11:03 AM
  5. Replies: 4
    Last Post: 05-21-2012, 08:21 AM

Tags for this Thread

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