Library code snippets

Storing Documents with MS Access - SharePoint lists or Access BLOB fields

How do I get started?

Here's what you'll need to do to play with this project:

(1) In the class module 'clsws_Lists', change the constant 'c_WSDL_URL' to point at your SharePoint site's list webservice

(2) In the module 'BLOB', change all of the following constants:

SharePointLinkedTableName: The SharePoint list as it is named in Access (via a linked table)

SharePointListName: The SharePoint list as named in SharePoint - same list as above

SharePointLinkedTableKeyField: "ID" (should be the same)

SharePointLinkedTableTitleField: "Title" (up to you!)

SharePointLinkedTableExternalKeyField: "ExternalKey" (up to you!)

SharePointLinkedTableDocumentDescriptionField: "Description" (up to you!)

SharePointLinkedTableDocumentPathField: "OriginalPath" (up to you!)

(3) Replace 'OEOSPDocumentList' (linked table in the Access Project) with a linked table that points at your SharePoint list... this list must support attachments, since that's how we are going to store the documents.  [When looking at your list in SharePoint, click on 'Edit in DataSheet', and then click on 'Task Pane'.  At this point, you can click on 'Create linked table in Access' to link the SharePoint list to this project file.]

Enjoy!

Comments

  1. 31 Jul 2006 at 10:02

    When i use the function StoreFileInSharePointList, when it execute the update into the linked table of my SharePoint list there's an error message : The field "Name" could not be Null, but this field has a value. How can i do ?

    Thank you

    Enrico

  2. 01 Jan 1999 at 00:00

Leave a comment

Sign in or Join us (it's free).

Sean Brady

Related podcasts

  • SharePoint Is Confusing

    That's right. I said it. SharePoint is confusing. What is the difference between Windows SharePoint Services (WSS) and SharePoint Portal Server? How do you add behavior to existing lists? How do you configure security for custom web parts? This is the show to help make sense of all the confusion....

Events coming up

  • Dec 12

    SharePoint Saturday Kansas City

    Overland Park, United States

    Join SharePoint architects, developers, and other professionals that work with Microsoft Office SharePoint Server 2007 for ‘SharePoint Saturday’, on Saturday, December 12th, 2009.

We'd love to hear what you think! Submit ideas or give us feedback