connect to a database with visual basic 2008

Question

How do I connect to an access database on the server if the server is avaliable? and if the server is not avaliable connect to the local access database when the application first starts up.
How do I switch the connection between the local database and the server database when the application has already started.
Thank you.