(Msg. 1) Posted: Tue May 01, 2007 11:51 am
Post subject: Query Mapping Archived from groups: microsoft>public>excel>querydao (more info?)
Hello...
I am able to create a simple query within one workbook. The SQL code
is:
SELECT `Sheet2$`.Facility, `Sheet2$`.F2, `Sheet2$`.`Hipper CT`,
`Sheet2$`.Chosen
FROM `Q:\Dept\Guest Services\FOC Scheduling\FOC Scheduling`.`Sheet2$`
`Sheet2$`
WHERE (`Sheet2$`.F2<=20) AND (`Sheet2$`.Chosen=0)
ORDER BY `Sheet2$`.F2
The problem I am having is if I move this file from the shared dive
(Q) to a local drive, the query won't run. Not everybody has access
to
the shared drive, so they will need to keep this workbook locally.
Without rewriting the code for each person, how can I achieve this?
Does MS Query need the mapping in the coding?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum