Ok Bill,
I can't make it work. I suspect I'm not describing the problem correctly.
I have all my forms, reports, code, querys, etc in a file called programs.mdb.
I have 1 table in another file called data.mdb. These both reside in a common
directory. This directory name is unknown to me until...