Access Directory

[Jeffry Montalvo]

Hello Everyone.
I created an access database that I would like to save data to a number of
directories. I created the directory via access 2000 and now I would like to
be able to change directories once I am using the database (through the
database). Example in DOS Command, is CD to change directory, what is the
access code to change directories within access 2000.

Thanks in advance,
JM

 

[Marshall Barton]

I created an access database that I would like to save data to a number of
directories. I created the directory via access 2000 and now I would like to
be able to change directories once I am using the database (through the
database). Example in DOS Command, is CD to change directory, what is the
access code to change directories within access 2000.

Sounds like a very strange thing to do.

The Access statement that's the equivalent to DOS's CD is
ChDir. See VBA Help for details and related statements.

However, I fail to see how that can be helpful. Almost
every operation the can refer to a folder/file allows you to
specify the full path, which is certainly a more direct way
to write information to a specific location.