First off I freely admit I am not programmer, I am IT support. I have user that is opening one access db and running a query. This query references another access db on a different drive. Someone in anothe rlocation is getting errors running the quey due to not ahve the same drvie mappings.

How can I mapped the trigger to the destination db manually and map full path instead of browsing to drive letter to map?

thanks for your patients with my lack of programming knowledge....