RE: can not connect to the mdb database

From: Amit Jain <jain_amit@xxxxxxxxx>
Date: Tue, 16 Aug 2005 23:34:02 -0700

Whats the error its thowing.

also pls verify the mdb path, and also reinstall the MDAC.

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

References:
- can not connect to the mdb database
  - From: Curie

Prev by Date: DataBinding Exception
Next by Date: Re: sometimes endless loop, sometimes not
Previous by thread: can not connect to the mdb database
Next by thread: RE: can not connect to the mdb database
Index(es):
- Date
- Thread

Relevant Pages

Re: Access 2007 ADP: incompatible ADO code
... I had a strange error like this working with an Access 97 Database and ... some ADO code that I was taking the other way. ... I re-installed the latest MDAC and the issue seemed to go ...
(comp.databases.ms-access)
can not connect to the mdb database
... table using the following ADO code in the Visual Basic 6.0 enviroment ... Dim myDB As ADODB.Connection ... myDB.ConnectionString = strConnText ... Prev by Date: ...
(microsoft.public.data.ado)