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

  • Feb 18

    Baltimore SharePoint User's Group February Meetup

    Baltimore, United States

    Join us for Thursday's BSPUG meeting as we welcome Rebecca Issermanfor a very informative session.Body:Hello all, hope the new year has started off well for everyone. Our next sessions is just on the horizon and it's time for the monthly BSPUG newsletter.On January 21st we will be welcoming Becky Isserman to the BSPUG. Becky has will be traveling far and wide to give her session and we'd love to have you there.

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