Work with Sharepoint lists offline
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<I found a couple of posts that indicate that these do not work properly.> On Runtime version?
ASKER
one referred to runtime, the other did not.
I'm still going to test when my server comes up.
Will post back, either way.
I'm still going to test when my server comes up.
Will post back, either way.
ASKER
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.
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.
ASKER
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.