Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    When linking to a SharePoint Server, is it possible to set a refresh interval?
    Thank you, Andy.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='andrewgibsonsw' post='792763' date='10-Sep-2009 03:57']Hello.
    When linking to a SharePoint Server, is it possible to set a refresh interval?
    Thank you, Andy.[/quote]
    Since no one else has jumped in, I have had one very brief experience with SharePoint a few months ago. My impression was that if the database is simple, it will work fine. Certainly exporting to SharePoint lists(? I forget the term) was pretty simple.

    In terms of refreshing, if you are using Access forms to interface with the data, you should be able to just use the timer event to run a sub that refreshes the data.

    If you are doing intensive updating of data, I found my database which worked very quickly with an Access backend ran excruciatingly slowly with the data in Sharepoint lists. 10, 15, 20 seconds to update data in a form. I recommended to them that they really needed to move to a SQL Server type of environment where the heavy lifting is done on the server side rather than the front end like Access does.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •