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?
Printable View
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?
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
So how do you connect to a msaccess database in vb6.0?
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