I am trying to create a program in to manipulate a parts database. What I would like to do is create a database of all of the parts that we use. Associated with each part is a datasheet in pdf format. My question is "Does MS Access have the capability to link file pathnames to specific entries in a table?" I want to create a program that allows the user to create a custom bill of materials from a list of available parts while at the same time automatically copying the datasheets (in pdf) of each part and storing them in a temporary folder. Is this possible with the Visual Basic/Access combination or do I have to look elsewhere?

Thank You

Marshall Stimpson

Access can fill your needs if you use VBA.