Choosing a connection at runtime

[venerable bede]

I have to point out in advance that I have only been using VB.NET for a couple of weeks so please be gentle.

I have finished creating my first application which consists of a front end in vb.net and a back end in access 2000.

I have just realised though that I will be installing the front and on a completly different machine to the back end.

Can anyone tell me, or point me towards any resources which will allow me to install the application and then in run time choose the location of the backend.

Thaks in Advance VB people

[Edneeis]

You just have to change the connectionstring property of the connection to match the new location of the database. You can use whatever means you'd like to get the new connectionstring an inputbox bringing up the datalink dialog or whatever. Then just replace the old string with the new and that should do it.