Relative Queries

P

Paul Hammond

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
 
E

exceluserforeman

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

Put this in module1

MpathY can then be the source word
 
Top