Relative Path in OLE DB string pointing to Access source

[Patrick Braunschweig]

Dear All,

I still have an open issue which I need to solve my problem. I'll kindly ask
you for your support.

Thanks in advance,
Patrick

Problem description:

No, because the whole model consists of a set of files. If I send this model
(with all its folders and excelsheets and the access source db) to a
colleague, then he will probably save that whole stuff in a different path -
that's why it won't work (And I must distribute it within colleagues).

So is there any possibility to set relative paths?

Thanks and regards,
Patrick

 

[Lori]

Try choosing Save As.. from the file menu, then just cancel before refreshing
or editing the query. This ensures the current workbook folder is active and
should connect ok wherever it is saved (hopefully!)

Note: When you enter a relative path in a connection string (or formula or
dialog box) it is relative to the active folder, not the current workbook.
Choose file open to see which folder is currently active.