In earlier versions of Access I'd present a hyperlink in a form, the
user would click on it, and an Excel or Word doc would open the
document up. From what I've read Sharepoint can be used for document
management. Let's say there are 3 legal documents that exist in
Sharepoint that are associated with a record in an Access database.
Can one easily present the data along with the documents in a form?
How does one present Sharepoint documents to the user?

"Patrick Finucane" wrote in message
news:697d361b-2235-45b5-b498-bbdf24a910f4 (AT) h9g2000yqi (DOT) googlegroups.com...

Yes, in this case there not really much difference between using a folder
with a bunch of documents in it or using SharePoint document site.

The major difference is that SharePoint is a web based interface. This tends
to be better connectivity and more choices for searching and viewing that
document site.

And now with SharePoint 2010 many of the documents can thus be viewed or
opened with a web browser.
However, the basic concept of a folder and you providing a URL to open that
document can certainly be done. As noted, this is not really much different
then providing a link to documents sitting on a shared folder.

So in theory your application could open and utilize those documents as long
as you have any Internet connection anywhere. This would be assuming you are
using hosted SharePoint or office 365. Or perhaps users have some type of
VPN secure connection to their company network which would thus include the
SharePoint site.

So the idea of using application.followhyperlink to launch a document
sitting in a folder or on SharePoint is much the same idea and works much
the same in both cases.

Of course the difference with SharePoint then is you can do things like
attach workflows to a document, so if a document is placed in a particular
library then everybody who supposed to review that new document can
automatically receive an e-mail.

And of course I things like searching of document "text" works far better
with SharePoint than it does with just a standard folder of documents placed
on a server, especially if one is connecting to the network.

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

On Sep 20, 9:35*pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:
Hi Albert, thanks for coming thru. I guess the crux of the matter is
that my experience with Sharepoint is about the same as a blind person
discussing visual objects. Basically I'm flying blind.

I know the documents pertinent to an upcoming application of mine will
be stored on Sharepoint. I was wondering how one presents Sharepoint
documents in an application. I assume the documents will be either
Word or Excel or PDF. I was wondering how one can "link, associate,
and display" the documents in Sharepoint for a record with an Access
web app.

As a side note, from what I've read I prefer calling an Access Web App
as a Sharepoint app instead.

I posted another message here earlier where I was hoping that there'd
be a book on designing a Sharepoint App in Access. So far I've been
sytmied in that search. I have found litte in regards to integrating
Sharepoint within an Access app.

The company is currrently installing or has installed its own
Sharepoint server. I don't know in what type of environment or
configuration. I want to be able to store information about a
document(s) in a record and then be able to also display it as well.

Do you have any suggested links for designing a Sharepoint App in
Access? I need to go beyond your video on YouTube and get into
specifics, the guts behind the form. How to maniuplate lists. Work
with Sharepoint workflows. Mainupulate Sharepoint lists, etc.
Present documents. Etc. Thanks