Results 1 to 9 of 9
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Access database with SharePoint lists as backend

    Hello!

    I am having severe performance issues with my database that uses SharePoint lists as the back end. Is this common? I get the hour glass or circle spin on nearly every field that is entered! It's terribly frustrating for all users. Assigning consecutive ID numbers doesn't work because of the delays in calculating the next ID, people end up with the same ID number. Is internet speed a key factor in this?

    There are maybe 4 users at a time. Using Access 2013/SP2013.

    Looking forward to your advice!!!! Thank you in advance.


    Gina

  2. #2
    jerem is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    88
    Hi,

    I use Sharepoint Lists as backend quite a lot. It is true that sometimes it can be a bit slow. Since Ms Access 2010, there is a new cache method though and it is pretty strong. Just check "Use the cache format that is compatible with Microsoft Access 2010 and later". Uncheck "Clear Cache on Close" and "Never Cache"

  3. #3
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Thanks Jerem,

    I have those settings. Any other thoughts?

  4. #4
    jerem is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    88
    If you take your application offline, do you see a significant performance improvement?

  5. #5
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Oh yea, definitely.

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Do your controls on your form have a "Post Back" property? Perhaps you can control when your server controls talk to the BE.

  7. #7
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by ItsMe View Post
    Do your controls on your form have a "Post Back" property? Perhaps you can control when your server controls talk to the BE.
    I don't think so since I don't exactly know what that means. It sounds like something I've been considering, having local tables and once a job is booked, clicking save or submit and push the data out to the server.

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Controls on a form that is designed for the web usually have the ability to not communicate with the server until the user does something. I am not familiar with SharePoint or Access Web forms. The way I understand it, Access 2013 does not use Web Forms and employs new techniques to communicate with SharePoint lists. This is why I am asking if the controls have a property for Post Back. There should not be a need for temp tables because the values can be stored in the client machine's memory.

    If there is not an intrinsic feature, I would probably be working with unbound forms and or controls.

  9. #9
    randy5566 is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    1
    I am not familiar with SharePoint or Access Web forms. The way I understand it, Access 2013 does not use Web Forms and employs new techniques to communicate with SharePoint lists.




    aaaaaaaaaaa

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

Similar Threads

  1. Synchronize Sharepoint Lists
    By jerem in forum SharePoint
    Replies: 7
    Last Post: 07-15-2014, 10:54 AM
  2. Replies: 0
    Last Post: 06-19-2012, 05:20 AM
  3. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM
  4. Sharepoint Lists vs Web database as backend
    By is49460 in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:27 PM
  5. Sync Fails with Sharepoint Lists
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 01-16-2011, 01:07 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