I finished my program and tried to make a setup application for it. I deployed the program and installed without any problem but it didnt work because of the database problem!

I used OleDbDataAdapter wizard to setup the connection and again generated the dataset from oledbdataadapter. I only wrote a simple code to fill the datagrid of my program with the table in my microsoft access database file. I think, I need to write some proper codes to setup a connection instead of using VB sh..t wizard. because when I try to run the program, it still tries to get the table from my C:\VisualBasic Projects\mypro\bin\db2.mdb and I want the program to be run on another computers directly. which codes do I need for this database connection and make my program a self executable file so my lovely supervisor can be able to run and test my program on his computer??

Professionally help needed!!