Access 2000 automation from VB6

[Mak Foka]

Can an Access 2000 database be opened from VB6?

I have a code that uses Access 97 databases. When I upgrade to
Access 2000 the code stops working for any database converted to Access 2000
format- Error "Unrecognized data format". Even newly created Access 2000
databases can not be opened from VB6.
The weird thing is that I can still open any Access 97 database form VB6
after the installation of Access 2000. The SR-1 office patch doesn't help.

Is there any known compatibility issue between VB6 and Access 2000?

Mak

[Deborah Kurata]

How are you opening the database?

Mak Foka wrote in message <38fcaa9e$1@news.devx.com>...
>
>Can an Access 2000 database be opened from VB6?
>
>I have a code that uses Access 97 databases. When I upgrade to
>Access 2000 the code stops working for any database converted to Access
2000
>format- Error "Unrecognized data format". Even newly created Access 2000
>databases can not be opened from VB6.
>The weird thing is that I can still open any Access 97 database form VB6
>after the installation of Access 2000. The SR-1 office patch doesn't help.
>
>Is there any known compatibility issue between VB6 and Access 2000?
>
>Mak

[Peter McKown]

I think Ms. Kurata hints at the most possible cause: how are you opening
the file? I noticed that when using ADO I had to reference the provider
as "Microsoft.Jet.OLEDB.4.0" rather than "Microsoft.Jet.OLEDB.3.51"

Good luck!


"Mak Foka" <mfoka@bispoint.com> wrote:
>
>Can an Access 2000 database be opened from VB6?
>
>I have a code that uses Access 97 databases. When I upgrade to
>Access 2000 the code stops working for any database converted to Access
2000
>format- Error "Unrecognized data format". Even newly created Access 2000
>databases can not be opened from VB6.
>The weird thing is that I can still open any Access 97 database form VB6
>after the installation of Access 2000. The SR-1 office patch doesn't help.
>
>Is there any known compatibility issue between VB6 and Access 2000?
>
>Mak

[Mak Foka]

Thanks Peter,
Your hint was very helpfull. I Checked the Office2000 web site
and realized that DAO3.6 was used in Access2000 and my application was still
referencing the DAO 3.51 library.
Mak

"Peter McKown" <mckown@ohio.edu> wrote:
>
>I think Ms. Kurata hints at the most possible cause: how are you opening
>the file? I noticed that when using ADO I had to reference the provider
>as "Microsoft.Jet.OLEDB.4.0" rather than "Microsoft.Jet.OLEDB.3.51"
>
>Good luck!
>
>
>"Mak Foka" <mfoka@bispoint.com> wrote:
>>
>>Can an Access 2000 database be opened from VB6?
>>
>>I have a code that uses Access 97 databases. When I upgrade to
>>Access 2000 the code stops working for any database converted to Access
>2000
>>format- Error "Unrecognized data format". Even newly created Access 2000
>>databases can not be opened from VB6.
>>The weird thing is that I can still open any Access 97 database form VB6
>>after the installation of Access 2000. The SR-1 office patch doesn't help.
>>
>>Is there any known compatibility issue between VB6 and Access 2000?
>>
>>Mak
>