dim conn As New ADODB.Connection, connStr As StringconnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\yourdb.mdb;Jet OLEDB:database password=XXXXXXXXXX"conn.Open connStr
dim conn As New ADODB.Connection, connStr As String connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\newquery\data.mdb;" conn.Open connStr
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\newquery\data.mdb;"
conn.Open connStr