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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External Data 0
Problem: Slow query design window using linked a tables over network. 1
ASK Field Formatting 1
Can't read Access db over network 19
Use relative address for database query 3
Change a cell reference from relative to absolute 2
Synchronization problems while moving folders to new email 1
relative path in OLEDB string 2

Top