Dim nomFichier As String Dim cheminPlusFichier As String nomFichier = "\compte.mdb" cheminPlusFichier = My.Application.Info.DirectoryPath & nomFichier File.WriteAllBytes(cheminPlusFichier, My.Resources.Compte()) My.Settings.EmplacementBdd = My.Application.Info.DirectoryPath & nomFichier
sBase = My.Resources.Compte.ToString ConnectBase(sBase) Public Sub ConnectBase(ByVal sBase As String) Dim strConnect As String strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" strConnect &= "User Id=Admin;Password=;" strConnect &= "Data Source=" & sBase cnx1 = New OleDb.OleDbConnection(strConnect) Try cnx1.Open() Catch ex As Exception MsgBox("Base de données introuvable." & vbCrLf & ex.Message, MsgBoxStyle.Critical, "Erreur de chargement") End Try End Sub