MartyConnelly
martyconnelly at shaw.ca
Mon Feb 28 21:06:11 CST 2005
How Access easily hooks into Sharepoint 2.0 which I think maybe one way MS is proceeding to allow you to get at a large document taxonomy. Here is how to quickly link Sharepoint Lists as Access Tables with 2003 and I think Access XP. File-->Get External Tables--> Link Tables brings up Link Form at bottom select File Types for "Windows Sharepoint Services" This brings up Link to Windows SharePoint Services Wizard Here you enter the http:// url of the site After that it links the Sharepoint Lists (think of them as access tables) If you open up a list (err a table) and there is at least one entry say a note or message click on the blue edit field This will automatically bring up an editor for that message in an IE window. Gunderloy on Access and Sharepoint http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_OfOfficeSysandWSS.asp Jim DeMarco wrote: >Hello All, > >First, if you sign up for the free trial make sure you get a password soon after signing up. I had to contact them for one (which I couldn't do as there was no contact info to be found on the site) and lost over a week of my trial even though I asked for an extension. I got a marketing call or e-mail (can't remember which) so I took the opportunity to tell the rep to get me set up and quick! > >Next, Sharepoint Services out of the box is a pretty cool tool. You can't ask for more than a place to collaborate and share contacts, docs, links, etc that requires no programming and easy admin. We just started using it within our dept. as an eval before making it available to various workgroups/departments. If you use Office 2003 it's even better with integration to open/edit documents in the doc library, the ability to see who's on-line. Plenty of smart tag activity too that lets you send a site member e-mail, get notifications if items are added or changed in various section (user definable too!). > >So far I'm loving it! > >The Portal Server adds the ability to customize or add your own version of some of the main sections plus I think it has advanced user management. > >HTH, > >Jim DeMarco > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock >Sent: Sunday, February 27, 2005 3:30 PM >To: accessd at databaseadvisors.com; dba-tech at databaseadvisors.com >Subject: [AccessD] Re: [dba-Tech] Overview of Sharepoint Server > > >Hi Marty and Dan > >Here's link which describes what's "Portal" and what's not: > > http://msdn.microsoft.com/library/en-us/dnanchor/html/Sharepoint.asp > > >Perhaps the "Portal" is what is charged heavily for while the >"Services" are free? > >/gustav > > > >>>>Gustav at cactus.dk 27-02-2005 20:13:36 >>> >>>> >>>> >Hi Marty > >Strange. Are you sure there is only one version? Perhaps like for >Exchange, an "Enterprise" version is available too? > >/gustav > > > >>>>martyconnelly at shaw.ca 27-02-2005 19:35:26 >>> >>>> >>>> >Microsoft Office SharePoint Portal Server 2003 (the current release) >is > >a Content Management System which belongs to the Microsoft Office >family. It is a collaborative portal application based on the Windows >SharePoint >Services platform, a free component of Windows Server 2003. Cheapest >form is Win 2003 server Small Business Version. I think based on WEBDav > >protocol. You also have to decide on using Windows SharePoint Services >and SharePoint Portal Server 2003, alone or in combination. >See to chose a suitable sharepoint version >http://www.gotsharepoint.com/ >or here >http://www.gotsharepoint.com/advisor/default.asp > >http://office.microsoft.com/en-ca/FX010909721033.aspx > >Content Management Systems >CMSs allow end-users (typically authors) to create new content in the >form of documents. These document may be entered as plain text or >perhaps >with markup to manage document layout and structure. The system then >uses rules to style the article, which separates the display from the >content, which has a number of advantages when trying to get many >articles to conform to a consistent "look and feel". The system then >adds the articles to a larger collection for publishing. The systems >also often include some sort of concept of the workflow for the target > >users, which defines how the new content is to be routed around the >system. A good example of a CMS would be a system for managing a >newspaper. In such a system the reporters type articles into the >system, which stores them in a database. Along with the article the >system stores >attributes, including keywords, the date and time of filing, the >reporter's name, >etc. The system then uses these attributes to find out, given its >workflow >rules, who should proofread the article, approve it for publication, >edit it, >etc. Later the editors can choose which articles to include (or ignore) >in an edition >of the newspaper, which is then laid out and printed automatically. >You >can also add wikki's blogs forums etc. > > >Gustav Brock wrote: > > > >>Hi Dan >> >>I don't have the exact cost. However, it is about USD 6000 for the >>server and maybe USD 100 for each seat (CAL). For a large company >> >> >this > > >>is peanuts but for our small clients it is prohibitive. >> >>As John says, it is in the Action Pack which we do have, but we >> >> >haven't > > >>bothered installing it due to it's very limited potential caused by >> >> >the > > >>license fees. >> >>/gustav >> >> >> >> >> >>>>>dwaters at usinternet.com 27-02-2005 17:18:04 >>> >>>>> >>>>> >>>>> >>>>> >>Hi Gustav, >> >>Do you know what the license costs would be? This could make the >>difference for my customer. >> >>Thanks, >>Dan >> >>-----Original Message----- >>From: dba-tech-bounces at databaseadvisors.com >>[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gustav >>Brock >>Sent: Sunday, February 27, 2005 9:26 AM >>To: dba-tech at databaseadvisors.com >>Subject: Re: [dba-Tech] Overview of Sharepoint Server >> >>Hi Dan >> >>One of the cons is the high license costs. >> >>I haven't been working with it. >>Does anyone know of a public Sharepoint server you can connect to and >>do live test? >> >>/gustav >> >> >> >> >> >>>>>dwaters at usinternet.com 26-02-2005 17:08:41 >>> >>>>> >>>>> >>>>> >>>>> >>I have a customer I've been trying to get a project started with for >>about 9 months now (large company). Two weeks ago we had what was >>supposed to >>be the last 'approval' meeting with a group of people from various IT >>functions. Yesterday my customer told me that a higher-level IT >>manager has suggested that he look at Sharepoint Server as a possible >>alternative before he makes a decision on what technology to use. >> >>So - can someone point me to where I can read a good overview of what >>Sharepoint does? What are it's pros/cons, etc. Beyond MS marketing >> >> >- > > >>how have people really used it to their advantage and what should it >>not be used for? >> >>Thanks! >>Dan Waters >>ProMation Systems >> >> > > > -- Marty Connelly Victoria, B.C. Canada