I am designing an Access 2003 database to keep track of clients and jobs and
what-not, but what I am trying to do is this.

I want a treeview and listview control on a section of my database that will
point to a specified folder on my hard drive for that client so that I can
access the clients files right through the database without having to do the
whole my computer\c:\drive\and so on.

In otherwords this is what I am trying to do.....

If I go to John doe's information in my database, I want a tab (which I
already have) with the treeview and list view control. The treeview would
automatically go right to this clients top folder and the list view would
display the contents and I would be able to browse through the folders and
open files right through access.

Has anyone done this before? If so, I need help bad. This is the only thing
I am stuck on.

Thank you,
James Gonier