I am developing a front-end for an access database.

Because the database will be on a server I need to, after installation, find where the database is and store the connection string in a text file.

When the application is run it reads the text file and stores the text file in a global "CONNSTRING".

I have managed to do this but am not sure where to add the "CONNSTRING" global in my code.

Should all of these:
Me.OleDbDeleteCommand1.Connection = Me.OleDbConnection1
Me.OleDbSelectCommand1.Connection = me.OleDbConnection1
Me.OleDbInsertCommand1.Connection = Me.OleDbConnection1

Read:
Me.OleDbDeleteCommand1.Connection = CONNSTRING
Me.OleDbSelectCommand1.Connection = CONNSTRING
Me.OleDbInsertCommand1.Connection = CONNSTRING

Another problem I have is that when running my program I get build errors because CONNSTRING contains nothing until run time.

I am new to this VB.Net and am finding these database issues difficult to get my head around.

Thanks in Advance