Greetings. Long time no post.

I need to play with documents stored in a SharePoint system. Can
anybody point me at a suitable book or Web site that would enable me
to do this from Access. What I initially need is a handle on the
SharePoint Object model and how to use it from Access. If it would be
a lot easier to use some other setup (VB.net for example) I'd be
interested, but don't really want to learn something completely new,
like C#. I expect this to be a one-off.

I need to:

Iterate through all the document libraries to find Word, PDF, Excel
and probably some other file types, storing the file names and
locations into an Access table.

Open each of these documents in turn to manipulate their content
programmatically, changing certain entries and re-saving them.

The second part is somebody else's problem, for now.

Take a look at Microsoft Access in a SharePoint World
http://store.advisicon.com/Microsoft...World-p62.html


"boatbloke" wrote in message
news:9bf85150-6c5b-4c31-a3f0-6d1e4585d19d (AT) o9g2000yqa (DOT) googlegroups.com...

Greetings. Long time no post.

I need to play with documents stored in a SharePoint system. Can
anybody point me at a suitable book or Web site that would enable me
to do this from Access. What I initially need is a handle on the
SharePoint Object model and how to use it from Access. If it would be
a lot easier to use some other setup (VB.net for example) I'd be
interested, but don't really want to learn something completely new,
like C#. I expect this to be a one-off.

I need to:

Iterate through all the document libraries to find Word, PDF, Excel
and probably some other file types, storing the file names and
locations into an Access table.

Open each of these documents in turn to manipulate their content
programmatically, changing certain entries and re-saving them.

The second part is somebody else's problem, for now.

"boatbloke" wrote in message
news:9bf85150-6c5b-4c31-a3f0-6d1e4585d19d (AT) o9g2000yqa (DOT) googlegroups.com...

There is a set of web services that you can call. Here is a good staring
point:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

I much suggest using the library if you want to call these web services from
Access.

In fact, you can actually get the web services definition from SharePoint by
simply typing in the URL of the web service in question.

When you do this then SP will return a list of of methods/properties.

And then if you click on one of the web service methods then you get the
required request + response headers for a given web service.

So the system is kind of self documenting but you need some code to setup
those request+response headers.

There is also a SharePoint client object, but this is for .net
http://msdn.microsoft.com/en-us/library/ee857094.aspx

I think it comes downs to if you want use .net or not. My personal pref is
using MSXML.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

Thanks Doug and Albert. I'll look at getting the book and delve into
the web services options. Most of my work for the last few years has
been totally data-centred so I'm out of touch in using Access to talk
to other apps.

Sorry it took a while to acknowledge -- I've been running about a bit.

Cheers

Albert Marshall
Currently in England