PDA

Click to See Complete Forum and Search --> : vb6 and msaccess2000

len
October 4th, 1999, 08:51 AM
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
October 4th, 1999, 10:13 AM
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
October 4th, 1999, 10:25 AM
So how do you connect to a msaccess database in vb6.0?
Vlad Chapranov
October 4th, 1999, 11:17 AM
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