I had created an access database to store path names of files on my local drive using the below vba code:
Dim rst As dao.Recordset
Set rst = MyDB.OpenRecordset("MyTable", dbOpenDynaset, dbAppendOnly)
! [File_path] ="Link" & "#c:\myfiles#"
I have only...