Hey,

How can I arrange that when I want to open my access database from
another computer, excel opens the correct database that is for example
on D:\ or on E:\, so that I don't need to give in the correct address.
So for example when I have a map called Thesis that contains my excel
file thesis and my access file thesis.

This is my code, but I want it to be relative or whatever it's called.

thx


s_Path = "C:\Documents and Settings\Eigenaar\Mijn
documenten\Thesis\thesis"
Set DB = OpenDatabase(s_Path)