Need to convert from embedded documents to linked documents

Question

I made a rookie mistake by embedding documents into a table instead of linking them. . . luckily, the documents are still in the same location that they were embedded from . . .does anyone have any VBA code that will run through the table and either build another table or add a field in the same table with the filename link so I can delete the embedded documents and revert to a link?

Answer 1

Okay, I just did a quick test by adding an Attachment field to a table and then running this code. It printed all the filenames I added to the table.

Public Function ListAttachments() As Boolean
'thedbguy@gmail.com
'9/27/2021

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim rs2 As DAO.Recordset2

Set db = CurrentDb()
Set rs = db.OpenRecordset("Table1")

With rs
    Do While Not .EOF
        Set rs2 = !docs.Value
        Do While Not rs2.EOF
            Debug.Print rs2.FileName
            rs2.MoveNext
        Loop
        rs2.Close
        .MoveNext
    Loop
    .Close
End With

Set rs2 = Nothing
Set rs = Nothing
Set db = Nothing

End Function

Hope that helps...

Answer 2

Hi. How many records/documents are we talking about? Is there too much to do it manually?

Answer 3

Yes . . .almost 5,000 records

Answer 4

Hi. Thanks for the clarification. One more question: Are we talking about an Attachment field or OLE Object?

Answer 5

It's an Attachment field