>Hi Phil,
>
>I have a question.
>
>I did this project at home with VB 6.0 and Access 97 and at work I have VB 6.0 and Access 2000.
>
>I just broght the exe file and database.mdb file to work for testing.
>
>I am getting a error with Jet Provider.
>error: (2147217887(80040e21)
>
>any way as you know,
>Provider=Microsoft.Jet.OLEDB.3.51 - access 97
>Provider=Microsoft.Jet.OLEDB.4.0 - access 2000
>
>Any way I understand why this is happening, but it shouldn't be a problem when just try to run the exe file.
>
>How can I make this program run for both Jet provider(3.51 and 4.0)?
>what can I do for this?
>
>Thank you Phil :)


Hi Lal,

The connection object holds properties of the provider. I don't think you can have two separate providers in the same connection. You may be able to do it through DSNs but I think the connection object will still store the provider details...I don't know.