Link to SharePoint

[andrewgibsonsw]

Hello.
When linking to a SharePoint Server, is it possible to set a refresh interval?
Thank you, Andy.

[PeterN]

[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.