RE: can not connect to the mdb database

It does not pop up an error message but I find out by debugging and check the
Access tables. When I go step by step debugging to MyDB.Open, the flow jumps
to the error trap I wrote to trap the error. Also, when I open the Access
table, the data is still there but they are supposed to be deleted.

Can you please tell me what is MDAC? Where do I find more information about
it?

Thank you,

"Curie" wrote:

> Can you show me what is wrong with this code? I can not open the database's
> table using the following ADO code in the Visual Basic 6.0 enviroment
>
> Dim myDB As ADODB.Connection
> Dim rsL As ADODB.Recordset
>
> Set myDB = New ADODB.Connection
>
> strConnText = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "DataSource = C:\Access\db1.mdb;"
>
> myDB.ConnectionString = strConnText
> myDB.Open
> Thanks
.