Access can't find text file to import

[sync]

How do I set up Access so it looks for an import file in the same folder as the mdb? I'm using TransferText to import and I don't want to hardcode the path so it can be used on different machines.

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Pathname for current database

 

[sync]

Sure the Search function works. But the brain that enters the search criteria doesn't always work.

Thanks.