T
Tom
Can I change my working directory in VBA? If so, how would I go about it?
I ask because I've started using the "another database" selection in my make
table query. I'm pointing it at my backend (data) mdb. If I run something that
I export, changing directories to do so, Access says it can't find my data mdb
in the directory in which I export my data, rather than the location where my
code mdb is (both the code and data mdb are located in the same directory). I
have to export something else, that I don't want to, just to change my working
directory back to the location of my code mdb. Then my query works without
error.
If I don't use "another database" selection, then when I run my make table
query, Access will delete the link and store the data in my code mdb.
Am I not trying to do this correctly?
Anyone have any ideas/thoughts/suggestions?
Thanks in advance,
Tom
I ask because I've started using the "another database" selection in my make
table query. I'm pointing it at my backend (data) mdb. If I run something that
I export, changing directories to do so, Access says it can't find my data mdb
in the directory in which I export my data, rather than the location where my
code mdb is (both the code and data mdb are located in the same directory). I
have to export something else, that I don't want to, just to change my working
directory back to the location of my code mdb. Then my query works without
error.
If I don't use "another database" selection, then when I run my make table
query, Access will delete the link and store the data in my code mdb.
Am I not trying to do this correctly?
Anyone have any ideas/thoughts/suggestions?
Thanks in advance,
Tom