>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