WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Query Mapping

 
   Home -> Office -> Query DAO RSS
Next:  Conditional Formatting question (if cell = 0, wra..  
Author Message
briansaito

External


Since: May 01, 2007
Posts: 2



(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?
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Query DAO 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET