By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Work Offline "if" SharePoint Connection hangs/fails

P: 207
Issue: SharePoint hangs (not exactly offline so MS Access does not switch to offline mode) and Access freezes on open.

Details: When my Access DB opens, it is prompted for a user to establish who is using the database to use in emailing/logging. This data is referenced from an online table (SharePoint) that requires authentication.

Check out this link for details on the authentication.

Question: My envisioned solution is to open the database and for it to capture the hang into an error handler; then move to an offline version of the database to allow the user to continue working when the SharePoint site is unavailable. How might I accomplish this?

Sudo Code:
Expand|Select|Wrap|Line Numbers
  1. User opens database
  2. Authentication prompt pops up
  3. If user can't/doesn't authenticate within "time"
  4. Cancel authentication and work offline
I know this might require me to change where the data lives for the "logged in" user, but is this possible?

I have looked {elsewhere} as an option, but I am not having any luck with forcing SharePoint to work offline.
Jan 2 '19 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,299
I'm guessing, from the wording of the title, that you are not aware of a way to determine or capture when it is that the site is unavailable. I'm guessing that if it simply hangs then you have nothing to work with as that's a baseline requirement for handling such a situation.

Other people may know more of course, but that would seem to me to be the starting point of the whole issue. Without that the rest is academic.
Jan 3 '19 #2

Expert Mod 2.5K+
P: 3,158

My experience has been that when I have accessed a SP library in a manner other than “using SharePoint”, the access will time out after a certain amount of inactivity on the site. I don’t know if this is due to my network nerds or server settings or a SharePoint feature.

Just thinking out loud here, but perhaps there is a way for your DB to somehow “ping” the SP library using a form’s Timer Event, maybe just to access some random data. This might keep the connection “open”? I don’t know enough about how SP’s connections work (and wee’ve discussed some of these challenges previously, I know).

Don’t know if that will hepp.
Jan 3 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.