Hi,

You mean that using dataenvironment is for steady file?

TIA

>>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