Public MpathY as string="M:\MyNetwork\MyFolder\MyDB.mdb"

Put this in module1

MpathY can then be the source word


"Paul Hammond" wrote:

I have several OLE DB queries that work just fine. The show a source of
M:\MyNetwork\MyFolder\MyDB.mdb.

Is it possible to make this a relative reference so that it just finds
MyDB.mdb when it resides in the same folder.

TIA,

Paul Hammond