file search path

[Guest]

I used to know this, but forgot. How does Access determine the search path
for files? I want it to look in the same directory as the program (the mde
file) first. But if I don't specify a path, it looks on a mapped drive--not
the one where the file is. I tried with a mdb file also, but it was the same.
I must have set this somewhere, but where?
Tools, Options has a "default database folder" but that doesn't seem to be
it.
Thanks for any help!

 

[Guest]

Application.CurrentProject.Path

 

[Guest]

How do I use that? It looks like something that would tell me the current
path, but can I use it to SET the search path?

 

[Guest]

You have to tell Access what path you want to search. This site has some
code that will allow the user to select a path and file. If this is not what
you want, look in VB Help for the Dir function.

http://www.mvps.org/access/api/api0001.htm

 

[Guest]

I was trying CurrentProject.Path and it worked once I fixed a typo. (I have a
public variable and set it to CurrentProject.Path, then told the program to
look there.) Out of curiosity, though, I wonder where the search path is set.
My network drive was certainly not a installation default, so there must be
some way to check/change that. Thanks!

 

[John Nurick]

Hi Joanne,

I don't think Access has a concept of a search path. It does have a
concept of a current directory: use CurDir(), ChDrive() and ChDir().