The TransferText command requires passing the full path and filename of
the TXT file to be imported. My users put the text file in the same
folder as the Access application itself. But how do I get the path name
of that folder?
The CurDir function does not do it. That function seems to return either
the computer's default path or the path to My Documents, neither of
which is what I need. The Access application is located on a mapped
network server drive and I have currenrtly hard coded the path into the
TransferText parameter string. But if teh drive mappings change I'm in
trouble.
I thought the Application object would have the proper path in it
somewhere, but I can't find anything like that there. Is there
someplace else I shoudl look?

Signature
Birk Binnard
http://www.birkbinnard.com
Ken Snell [MVP] - 24 Aug 2005 20:52 GMT
This will tell you the path where your "front end" application file is
located:
CurrentProject.Path

Signature
Ken Snell
<MS ACCESS MVP>
> The TransferText command requires passing the full path and filename of
> the TXT file to be imported. My users put the text file in the same
[quoted text clipped - 11 lines]
> somewhere, but I can't find anything like that there. Is there someplace
> else I shoudl look?