2 Databases in the same folder

[Boon]

Hi,

I have a folder name "Project" in this folder, I have 2 database files -
Main.mdb and Data.mdb.

I have a Make table query in Main.mdb. the Make query will make a table in
Data.mdb. Right now I setup a path in the make table query as
C:\Project\Data.mdb.

I want to make the query independent of the path. That is, I want to be able
to move the folder Project to other places (D:\, E:\Document\Test\,..., or
even the different machine) and the query still works fine.

Thanks,
B

 

[MGFoster]

Hi,

I have a folder name "Project" in this folder, I have 2 database files -
Main.mdb and Data.mdb.

I have a Make table query in Main.mdb. the Make query will make a table in
Data.mdb. Right now I setup a path in the make table query as
C:\Project\Data.mdb.

I want to make the query independent of the path. That is, I want to be able
to move the folder Project to other places (D:\, E:\Document\Test\,..., or
even the different machine) and the query still works fine.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'll have to use VBA to dynamically construct the SQL statement w/ the
new folder info.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSjvvMIechKqOuFEgEQIWkACgrL3HKJ7NMbMJ5P+b0jrcxjAea5gAn3Fb
S9I2Lx7EmR7iXTPcLVUT3FuA
=osoh
-----END PGP SIGNATURE-----