Importing access 2007 attachments into wss linked table

[BLouie]

I exported a list from Sharepoint into Access 2007. Using DAO I want to
programatically add attachments. I am using VB, specifically the
LoadFromFile method of the recordset field property. I keep getting an error
when I step through the LoadFromFile line (...invalid argument...).

I tried a simple test by creating a new table in access 2007 with an ID
(autonumber) field and an attacment (attachment) field. LoadFromFile works
fine.

The error only seems to occur when I use LoadFromFile on the the child
attachment recordset of the attachment field when it is linked to Sharepoint.


The code I used as a base is found in MSDN @
http://msdn2.microsoft.com/en-us/library/bb258184.aspx
Any suggestions would be greatly appreciated.

 

[Tom Wimpernads]

DAO is obsolete, you will need to do this with ADO

 

[Tom Wimpernads]

I would not reccomend actually RELYING on sharePoint for anything

I gained this perspective when I was on a sharePoint migraiton and Access
couldn't physically import 10,000 records into sharePoint in less than 2
hours


SharePoint isn't business ready-- and I don't think that M$ should be
conning us into buying a new version TWICE by introducing new buggy ass
features

who gives a crap about SharePoint

if you want webdev then get a copy of DreamWeaver.
MS doesn't understand the web paradigm and they never will

 

[BLouie]

Couldn't get this working, so have come up with a different (better???)
solution. We originally wanted to store the attachments directly on a
Sharepoint Issue in an attachment field. Instead of doing this, since we
also use Sharepoint to store all of our documents (as well as all of our
issues), I now loop through the original issues list, saving the attachments
via DAO SaveToFile to a folder in sharepoint. I then update each new issue
with an <href> in a memo field that links back to the saved attachment. This
solution also gives the added benefit of using the security as set up in
Sharepoint.