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

You can open, without any problem, an Access 97 database with the 4.0 version of the Jet OLEDB provider!