The attached database is a small example of how we can use the file system object (FSO) in Access for "attaching" files to our database.

the FSO is very customizable, allowing you to add your own filters etc - many examples are applied in this project.

Any paths and names of files selected using the FSO are stored in a table in the database, this can be very useful for bookmarking files, creating favourites list etc etc.

The FSO object requires the use of a reference called "Microsoft Office Object Library 10.0" (or above). The On_Load() event of the form automatically checks the access version and adds the reference by GUID.
More information on GUID's can be found here.

The code is commented pretty well but if you have any questions then feel free to PM me.
-------------------
EDIT: 2007-06-28
Added more functionality including a variation on the FSO which allows you to select folders as opposed to files. Minor coding tweaks and tidying up.
-------------------

~ George