Error 3001 in Access 2007 adding Attachment to linked Sharepoint t

M

msumrell

The problem I have is within VBA code in Access 2007.

If you link a Sharepoint table into Access and try to add Attachments to an
Attachments field (using VBA), you will get the 3001 Error.
If you view the table in datasheet mode and use the built-in Attachment
Control to add/remove attachments to the field, everything is fine.

There are several examples on the web and MSDN on how to programmatically
add/remove attachments using DAO.Recordset2 and DAO.Field2. These examples
work fine if the complex field is created locally in Access, but does not
work if the field is linked from Sharepoint.

Is there a known reason why the internal Access Attachment Control works on
the linked Sharepoint table, but the VBA equivalent does not?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ms Access 2007 and Ms Sharepoint 2007 (Issue with Attachments) 2
No option to create a list in SharePoint Site 0
Word VBA - Want to test if Full Name is NOT Present in document 0
attaching a file to a sharepoint record 1
Error 3001 recordset find sql 3
Autonumber field in Excel that behaves the same as Access 0
Email the files in the Attachment Field from Access 2007 1
Appending to Sharepoint List From Access 0

Top