You can use the OpenSaveFile API to do this. You can find the basic
information here:
http://www.mvps.org/access/api/api0001.htm

Signature
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
> I am finding it difficult to find a way to get an automated way of storing
> the file name of an external document in an access table, does anyone know a
> way to
> find the file and then save it in a table record?