Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening Using ADO in multi file
Message
 
À
25/11/1999 08:35:36
Larry Santos
Local Data System
Philippines
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00295515
Message ID:
00295537
Vues:
25
>Any idea of opening an MDB (database) with the use of ADO or evironment, just like calling a dialog box and transfer in ADO code or data environment...

You can open your connection using code only (no DataEnvironment) like this:

Private mdbConnect As ADODB.Connection

Set mdbConnect = Nothing
Set mdbConnect = New ADODB.Connection
With mdbConnect
.Mode = adModeReadWrite
.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=c:\temp\BD.mdb;"
.CursorLocation = adUseClient
.Open
End With
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform