i have a VB program that access a microsoft access database dbcourse.mdb in this path c:\course\dbcourse.mdb..all the bound countrols access this database in this path set in its connection string.
e.g.
adodc control
connectionstring=c:\course\dbcourse.mdb.

my problem is, actually its more of an inquiry than a problem..
if i install the system to another computer, should i really need to copy manually the course folder containing the dbcourse.mdb file to drive c? or there is another way of automatically installing this with the exe file?

i really wish i can deploy the program by just a click of setup.exe and all the needed files like *.mdb will be all in its place.

how should i do it?

thanks in advance for your help...