Connecting MS-ACCESS to SharePoint

[lim_sup]

Hi,
I am developing an ACCESS 2007 application that must query a remote SharePoint list over the internet. I am using ADO to connect and trying to follow VBA code from Litwin, Getz, and Gilbert that looks like:

Dim cnn as ADODB.connection
Set cnn = New ADODB.connection
With cnn
.Provider = “SQLOLEDB”
.Properties(“Data Source”) = “Gorilla”
.Properties(“Initial Catalog”) = “ADH2KSQL”
.Properties(“User Id”) = “Suzanne”
.Properties(“Password”) = “mud”
.open
End with

My questions are:

1) Does this seem like the right way to do this?

2) Instead of "Gorilla" (Data Source) would I use the IP address of the server, like "www.remote.server", and do I need to specify a port number?

3) How would I look for the needed parameters within the SharePoint configuration.

Please forgive my ignorance, the SharePoint administrator just quit, and though I can get access to the configuration, I know very little about SharePoint.

My 0verall objective is to use ACCESS to post files to the SharePoint list, retrieve the document URL from the SharePoint List , and then update additional SharePoint document attributes from the Access database. So far I have been unable to guess the parameters needed for a successful connection.

Thanks. Any comments or suggestions will be appreciated.

[NTC]

I myself would not go this route. Access2007 has a SharePoint Lists area in the External Data tab of the ribbon. I would rely on this.

When the sharepoint server is not co-located on the same LAN - the work-ability of a linked connection is doubtful. This is due to the slow speed of the internet (compared to a LAN). One instead uses the import/work locally method to bring the data in locally - do your work - and then resync it back to sharepoint. You will want to refer to your Access2007 text book on this.

Hope it helps.