Question Programmatically accessing OLE attachments (1 Viewer)

June7 said:

Bing: Access VBA extract OLE Object

Click to expand...

1. MS Access 2000 as a frontend
2. The attachments were created using "Create from File" dialog
3. SQL Server 2010 is the backing database.
4. The table is called contact_items_buf
5. There are two columns: nr and buf. The actual file seems to be in the buf column.
6. Type of column buf is image
7. It appears the original filenames are not preserved
8. The value stored in the column is not the file itself, I tried saving that as a binary file with the correct extension, but Word was not able to open it.

mzafkismugi said:

Since both approaches didn't work for me I decided to dig in but I'm stuck. What I know so far:

1. MS Access 2000 as a frontend
2. The attachments were created using "Create from File" dialog
3. SQL Server 2010 is the backing database.
4. The table is called contact_items_buf
5. There are two columns: nr and buf. The actual file seems to be in the buf column.
6. Type of column buf is image
7. It appears the original filenames are not preserved
8. The value stored in the column is not the file itself, I tried saving that as a binary file with the correct extension, but Word was not able to open it.

Is there any hope for me or I'll have to do it manually?

Click to expand...