Need MS query to check Current Directory

P

Patti

I need to know how to make MS QUERY queries look at the
CURRENT workbook Directory instead of the creation
directory which it imbeds.
I am NOT talking about the default directory in tool ->
options-> general -> default file location.
Example of query MTHLYISSUE.DQY
XLODBC
1
DSN=MS Access
Database;DBQ=C:\PROJECTS\BKL200401JAN\BOOKLEND.MDB;DefaultD
ir=C:\PROJECTS\BKL200401JAN;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;
SELECT MonthlyIssuances.IssuanceMo, Sum
(MonthlyIssuances.BookCnt) FROM BookLend.MonthlyIssuances
MonthlyIssuances GROUP BY MonthlyIssuances.IssuanceMo
ORDER BY MonthlyIssuances.IssuanceMo DESC

I need to edit this query so that it looks for the Access
database BOOKLEND in the Directory where workbook (and
database) is being used from (CURRENT directory) not where
the original workbook was created.

Each month the workbook and database are copied to an new
folder, the database is updated, and new pivot tables and
reports are generated from this. I need to be able to
give this to other people to run without them having to
edit the query. There are 6 others within this workbook

Thanks
Patti
 
Top