Moving attachments between tables in Access 2007

J

Jason Ede

I've got an access 2007 database and some tables with attachment fields
defined in them.

When I try to move the attachments between tables in VB by just copying the
field across I just get an error. I know there just be a simple way of
moving them between tables, but I can't seem to find it.

Jason
 
G

Guest

Hi Jason, I am having a similar issue, just wondering if you found a solution.

One article that did help me understand a little more about attachments in
Access 2007 can be found in MSDN @
http://msdn2.microsoft.com/en-us/library/bb258184.aspx

My problem seems to be updating the attachment when it is in a linked table
into a Sharepoint site. The code from the above article works fine for me
when the table lives directly in Access.
 

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

union queries - with tables containing fields with attachments 2
linking tables and relationships 3
Cleaning up ER diagrams in Access 1
Relationships between multiple tables 5
Problems with query relationships in linked foxpro database tables 3
See Linked Tables in Access 2007 2
creating foreign key 2
Where should I define relationships for external tables? 1

Top