In access I would like to link a (.pdf.xls.doc) to a DB record

[Guest]

I am tasked at creating a document management database for work. with
(Microsoft Access) I have a multitude of documents that I would like to
create metadata for and link to a database that I will compose. The database
will house all of the metadata pertaining to each document. I envision a
folder directory containg the seperate types of documents seperated by
resource, wetland, wildlife, soil, and water etc. Doc type and resource will
be a drop down list in the access DB. Other fields would include the Author,
title, size, DocID, Date, resourse type and Is there a way to connect the
document with the document's metadata. How would I proceed in setting up a
database of document metadata while linking to a folder structure containing
all the documents?

(e-mail address removed)

 

[Albert D. Kallal]

If you store the full path to the document, then you can place a button on
your form to open this document.


application.FollowHyperlink me!MyFieldWithDocName

I suppose, one should consider a design where the path name is separate from
the document name for display purposes, and perhaps easy facilitation of
changing a directory where the files are stored. Regardless, you just need
to store the path name + doc name in a field (or fields) in a record, and
the above code would launch/open the document...