B
Boon
Hi,
Here is my situation.
I have 3 database files stored in a folder. There are queries that make
table, append between database. (ie. Click make table in database1 to make a
table in database2.)
Currently, these 3 databases are stored in my laptop at path -->
c:\documents\project\Customer\
I would like to be able to move the folder Customer (which contains 3
databases) to other place and still be able to do the work. For instance, I
want to move the folder Customer to D:\Backup\August\Customer. Ultimately, I
want to move this to other PCs as well.
The problem is in the make query, I specify the path as
c:\documents\project\Customer\. Thus, when I move to different path, the
query doesn't work.
How can I make the query independent of the path. Just look in the databases
in the same folder it resides, or in the subfolder in the same folder in
resides?
Thank you,
Boon
Here is my situation.
I have 3 database files stored in a folder. There are queries that make
table, append between database. (ie. Click make table in database1 to make a
table in database2.)
Currently, these 3 databases are stored in my laptop at path -->
c:\documents\project\Customer\
I would like to be able to move the folder Customer (which contains 3
databases) to other place and still be able to do the work. For instance, I
want to move the folder Customer to D:\Backup\August\Customer. Ultimately, I
want to move this to other PCs as well.
The problem is in the make query, I specify the path as
c:\documents\project\Customer\. Thus, when I move to different path, the
query doesn't work.
How can I make the query independent of the path. Just look in the databases
in the same folder it resides, or in the subfolder in the same folder in
resides?
Thank you,
Boon