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)
With rst
. AddNew
! [File_path] ="Link" & "#c:\myfiles#"
.Update
rst.Close
I have only...