[AccessD] Re: [dba-Tech] Overview of Sharepoint Server

One thing I found out that isn't clear in Sharepoint, is that you have 
to assign web designer or contributor rights to a user
even if user is the administrator in order to upload an Access Table.
Now I just have to figure out how to link pictures on the site into the 
list (table).
Maybe I have to do this with xml web services.

Sub WWSupload()
On Error GoTo errout
DoCmd.TransferDatabase transfertype:=acExport, databasetype:="WSS", _
                       databasename:="http://username.sharepointsite.com", _
                       objecttype:=acTable, Source:="Household Inventory", _
                       Destination:="Household Inventory", 
structureonly:=False
errout:
Debug.Print Err.Number & "-" & Err.Description
End Sub

Martin Reid wrote:

>
> Jim
>
> heres another article
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pjsdk/html/pjsdkWebpInstallAndWSS_HV01100336.asp 
>
>
>
> Martin
>
> On Mar 1 2005, Jim DeMarco wrote:
>
>> Are we able to create and use custom web parts if we are only using 
>> Sharepoint Services (not Portal Server)?
>>
>> Jim DeMarco
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid
>> Sent: Tuesday, March 01, 2005 10:02 AM
>> To: Access Developers discussion and problem solving
>> Subject: RE: [AccessD] Re: [dba-Tech] Overview of Sharepoint Server
>>
>>
>> LOL
>>
>> I have been discussing some stuff of list.
>> But in general SP also contains its own security systemn with lists 
>> etc. I am doing two major reviews for a publisher on Sharepoint. I 
>> also did a section on FrontPage 203 for Microsoft and I know there 
>> are a few articles up on MSDN. Have a look for FrontPage 2003 and 
>> Sharepoint. Paul Litwin wrote an article at the same time as me for 
>> them which dealt with Web Parts/XML and Access.
>>
>> Its really a trinity of Products - FrontPage 2003 (or .NET) 
>> Sharepoint services and SharePoint Portal Server. The Portal Server 
>> provides great indexing and searching capability for Sharepoint 
>> Services. But the main development tool is Web parts. Web parts 
>> provide descrite functionality for example a set of data from SQL 
>> Server, DB2 etc. ALso provides a single sign on cabability for 
>> multiple systems.
>>
>> Martin
>>
>>
>>
>> On Mar 1 2005, Susan Harkins wrote:
>>
>> > I think Martin's writing a book on SharePoint -- you might ring his 
>> > chimes.
>> > > Susan H. > > Marty,
>> > > Under the paragraph Using Sharepoint Lists, Mike states that > 
>> Sharepoint > uses an optimistic record locking scheme. This would let 
>> > me use an Access database as read-write for one location and 
>> read-only > for any others.
>> > > Still, that could be useful in some situations.
>> > > Dan Waters
>> > ProMation Systems
>> > >
>>
>

-- 
Marty Connelly
Victoria, B.C.
Canada