How do you create deployment when data on CD?

Question

I am trying to create a Install of a VB.NET program that I have written. I am using an Access DB and it will be large enough that I want the user to access this from the CD. How can I do this? How can you have your data separated like this and put into another area than the program is in? I will not know what drive letter the user is using. Thanks, Al

Answer 1

SELECT Empid,Empname,Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid

This is the best code.

Answer 2

SELECT Empid,
            Empname,
            Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid