Work with Sharepoint lists offline

Dale Fye
Dale Fye used Ask the Experts™
on
I've got an Access 2007 app that is using Sharepoint (MOSS 2007) lists as my
data store.

Some of my users are experiencing extreme latency issues, so I'm testing allowing them to take the data offline, and then resynch later.  In my testing, Ive done this using the options on the "External Data" tab of the ribbon.  However, in my application, I hide the ribbon from my users, presenting them with ribbon functionality through shortcut menus.

I've found the code for taking the lists offline:

Docmd.runcommand acCmdToggleOffline

but cannot find any VBA code references to either synchronize the data with the sharepoint lists or reconnect, both of which do some conflict resolution.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
try this two

acCmdSynchronize
acCmdSynchronizeNow


here is the list of commands
http://msdn.microsoft.com/en-us/library/bb225843.aspx
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
Cap1,

Thanks.  I'll check those out as soon as my SharePoint server comes back up.  Unfortunately, it is down at the moment and none of the IT types are in the office because of the weekends snow storm.

Neither of these seem to be documented anywhere, but when I did a google search on "runcommand +acCmdSynchronize +2007" I found a couple of posts that indicate that these do not work properly.

Top Expert 2016

Commented:
<I found a couple of posts that indicate that these do not work properly.> On Runtime version?
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
one referred to runtime, the other did not.

I'm still going to test when my server comes up.

Will post back, either way.
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
I tried both options, and neither worked the way I expected, and both left a messagebox on screen when they were done.

Appreciate the response.  At least I now know which runcommands apply to this situation, even if they don't work properly.

Maybe MS will fix this in the 2010 version.
Top Expert 2016

Commented:
:-(

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial