MartyConnelly
martyconnelly at shaw.ca
Thu Feb 23 12:18:54 CST 2006
Another way to go depending on security concerns is to use a hosted or dedicated WSS server. I used this for a trial demo last summer. There should be other hosting sites out there. Hosted for 100 users is about $60 a month +extras like named url and ssl It is a Norwegian-US firm Apptix, servers based in Virginia. IBM and Bell Canada use it. They have a free 30 day trial., if you want to put up a demo. http://www.sharepointsite.com Here is a quick Windows Media File to show easy linking of WSS lists and Access tables and running a query on them from Access 2003 to produce a mail list. http://www.wssdemo.com/Demo Documents/Access.wmv You can also run SOAP and WebDAV against WSS for external users. or even get XML rowsets knowing the GUID of the WSS list via a url that looks like this http://server/site/_vti_bin/owssvr.dll?Cmd=Display&List={E1D9FED5-2531-413F-8C0F-CAA5C6280E51}&XMLDATA=TRUE The following Access 2003 VBA example exports the contents of the Inventory table to a new list named HouseHold List on the Windows SharePoint Services site. DoCmd.TransferDatabase transfertype:=acExport, databasetype:="WSS", _ databasename:="http://mconnelly.sharepointsite.com", _ objecttype:=acTable, Source:="Inventory", _ Destination:="Household", structureonly:=False Dan Waters wrote: >I have a potential customer who might benefit from using Sharepoint. They >are only about 100 people, but have sales and field reps in several places >in the world. What does Sharepoint cost? > >I've read before that a list in Sharepoint can be connected to an Access >database. If my customer does use Sharepoint, then I believe I can give him >some database functionality collaborating with widely dispersed people. Has >anyone used Sharepoint with Access? > >Thanks! > >Dan > > > > -- Marty Connelly Victoria, B.C. Canada