ado could not find the specifiec provider

[Bebe]

ado could not find the specified error is what i am getting

that's the error im receiving here is my code:

Set mCN = New Connection

With mCN
.ConnectionString = "Provider=Microsoft.jet.oledb.4.00;datasource='c:\my documents\people.mdb'"
.CursorLocation = adUseClient
.Open


does anyone have an ideas what the problem could be; i would appreciate any help.

i have mdac 2.1 installed

i was using the same provider but with 3.51 and received an isam error and then i changed it to 4.00; which is what i need it to be as i am using an access 2000 database.

[Clunietp]

change datasource to data source

[Clunietp]

Oh yeah, and Microsoft.jet.oledb.4.00 to Microsoft.jet.oledb.4.0

[Bebe]

You were right on both accounts. I have to change recordsource to record source and 4.00 to 4.0 for to work and now it works!!!

thanks!!!