Update CD drive letter per user

[Guest]

Hello,
My company stores a LOT of data in Microsoft Access tables, and I have
built some queries for that data. Since running them over the network is
slow, we will be handing out CD's for users to run the queries. Not everyone
will have the same CD drive letter...example it could be E for me, but F for
the person next to me.
So far, we are going to have the user input their CD drive letter when
they open the Microsoft Access query file. After they do that, how do I
update the linked tables to reflect what letter drive the user input? Any
suggestions?

Jessica

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" for one approach.