I was attending the SharePoint Developers Group Meeting (http://www.dspdg.org) last week and the presenter, Ty Anderson, of http://www.cogentcompany.com & http://www.officedeveloper.com demoed using MS Access as a shim to bridge the communication between a VSTO application and a SharePoint List. I thought the idea was cool so I threw together this quick sample for your consideration. Note: I have not tested this in a multi-user environment, nor would I recommend this when performance is a high priority. Regardless it is very cool! Step 1: Create your list in SharePoint: Here you can see my TestList, it has one column called...
Need I say more? http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42
Ever wanted access to that treasure trove of information available in SharePoint lists scattered across your enterprise? Ever wanted to provide a quick and dirty UI for users to enter data, but need to have programmatic access to the data? Use SharePoint! SharePoint provides WebServices that give you access to just about everything you can think of (http://msdn.microsoft.com/en-us/library/ms954015.aspx). For the purposes of this article I am going to use the Lists WebService to 1) get data from a list, 2) Add an item to the list and 3) Delete an item from the list.
The first step is to add...
Having a problem getting the Explorer View in SharePoint working, Microsoft has a service that needs to be running on your computer to facilitate that function. Make sure the WebClient service is started. Take a look at this KB article for more information (http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/844f5e01-4b9e-4dac-897e-2a0bb33f28af.mspx?mfr=true).
Note: This doesn’t seem to affect IE 7, another reason to upgrade. . .