i am trying to create a new sql connection

Dim mySqlConnection As New SqlConnection(conString)

what should be the value of conString if my database is C:\myDB.mdb (local)

also, can you create a DataAdapter that is not specific to a single table in the DB?
so that when I say

myDataAdapter.Fill(myDataSet)

it fills myDataSet with the entire DB, not just the single table designated by
Dim DataAdapter As New SqlDataAdapter("SELECT * FROM myTable", conString)


any answers?