How do I link a windows folder to a record?

[joefox]

I created an OLE object field in a table and created the form based on the table. In Form view I right clicked on the OLE field, selected Insert Object, and went to the folder I wanted to link. It doesn't allow you to link a folder. So......I create a shortcut (.lnk) thinking I can link to that file which will launch the folder. It doesn't work either.

I am simply trying to include a link and a form so the I can open a folder containing project related documents.

Any advice would be appreciated!!

Joe

 

[mckenneyj]

As of Access 2000 there is a data type for fields called hyperlink

Thanks,
John McKenney
Work Hard... Play Harder