vb6 and msaccess2000

[len]

Is there a problem with vb6 accessing MS Access 2000? I keep getting unrecognized format for the mdb file. Is there a patch for vb6 to correct this problem?

[Vlad Chapranov]

There is a lot of previous postings regarding this problem. DC doesn't work with Access 2000. And there is no patch at all.
Vlad

[len]

So how do you connect to a msaccess database in vb6.0?

[Vlad Chapranov]

I have to have several DC in my project. To make DC work with Access 2000 you can create DAO Recordset object (DAO 3.60 reference) and assign it to Recordset property of DC. Be aware that Crystal is not compatible (except Maintenance Release 1 for Crystal 7.0) with Access 2000. Because of many problems I couldn't upgrade my database to 2000 format so far. My project is still using 97 format. M$ sais: "Use ADO", but it's slow with Access. Next advice:"Use DAO only". But I have already DC, what to do? We don't know. That's it.
Vlad