Upload .pdf file to Sharepoint document library using Access vba

Question

In Access 2007, I create a static report in .pdf format. I want to create it and then export a static report (not the data itself) to a SharePoint document library. The goal is to make it a public repository, without version control. Each report will have a unique name.

I am an experienced vba programmer, but using Sharepoint services is new to me. How should I do it? Suppose I can determine the name and location of a file after it is created, and I know the URL of the Sharepoint library and have permissions. Where am I going from there?

Answer 1

Microsoft has done a bit of magic in SharePoint so that libraries appear as Windows network shares for clients. That way, your program can simply save the file in a UNC path.

So, if you are logged in as a user with library permissions and the library URL is http://SHAREPOINT/Department/Files/(for example), you can simply save or copy the PDF files to \\SHAREPOINT\Department\Files\.