Check Sharepoint Online Status (VBA/Access 2007)

[drjohn61]

Hi all,

OK, I have searched and searched...

I have a few tables set up in Access 2007 that are links SharePoint lists. I have successfully found the code and set it up to toggle SharePoint on- and offline (as well as sync when offline). When using the toggle command, it shows in the status bar whether SharePoint is on or offline and it toggles the button in the ribbon (which I have hidden). I would like to set up a better indicator of online status than the status bar, like renamiing my toggle button according to status. I know that there has to be way to set up a function that checks the SharePoint online status via code but I can't find anything anywhere on how to do it.

Any help is greatly appreciated!

Thanks,
John

 

[drjohn61]

For anyone interested, I have come up with a solution. It is a work-around kludge, but it works until I can find a better solution.

I created a dedicated table in SharePoint that I write a record to, check to see if the ID is <0 and then delete the record. If the ID is <0 then SP is offline, since any new cached records have a negative ID. Like I said, a kludge, but it does work.