Hi. I have an Access DB that resides on a network drive. Not
everyone in my company maps the network drive the same. Anyone can
map it with any letter (ie - drive H: M: etc). The database looks
for
a text file in the same root directory where the DB resides to email
it. Since anyone can map there drive letter, i need a relative path
to the text file. Is it possible to have the access DB look for the
text file using a relative, rather than absolute path?
It currently works for anyone mapped as H. See below..
BodyFile$ = ("H:\Customer Service\CiRT\CIRCUIT REQUESTS ETC
\emailbody.txt")
I need it something like this:
BodyFile$ = (".\emailbody.txt") or BodyFile$ = ("emailbody.txt")
I tried CurDir$ and App.Path but I'm not getting anywhere...
