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
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!)
Related articles
Related discussion
-
How to control IE from VBA
by NaseemAhmed (0 replies)
-
sharepoint calendar web part with events from sql table
by converter2009 (2 replies)
-
Excel 2007 Error : ' the digital signature is deleted when Excel users tries to save the Master Excel Spreadsheet.'
by jdierkes (0 replies)
-
Excel VBA transposition problem
by KDHTSVAU (2 replies)
-
excell question
by Uncle (11 replies)
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.
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
This thread is for discussions of Storing Documents with MS Access - SharePoint lists or Access BLOB fields.