Very easy relative directory question.

[Flashbond]

Fist of all, Hi guys! I am very new to this forum.

I have an excel file and it is in the same directory with the access file. I want to assign a relative directory to link this xlsx. I tried "..\" trick but it didn't work. The idea is, as you'll guess, I want to use them where ever I move these two files (.accdb and .xlsx) together. I don't want to be bound to a directory address. The magic rule is I don't want to use VBA.

Any idea?

Thanks a lot!!

[June7]

I don't think Access has relative pathing. File must be re-linked. This can be done progammatically.

VBA can retrieve the current path of the db and set a variable with that string. I don't think macro could do that.

[Flashbond]

Ok, I see... It was because, I don't want to run macro each time I open the document
Maybe something like "file:///fligt_search_analysis_report.xlsx"?!

[June7]

The code would run so fast, wouldn't even know it was happening. Code could be behind a form set to default open when db opens.

I doubt macro can be used. I relink with VBA. Example code in http://forums.aspfree.com/microsoft-...ue-323364.html