VB can't open Access2000 database
To be specific, you need to replace the reference to DAO 3.5 (or 3.0) with a
reference to DAO 3.6 (under Project, References). And you also have to set
the connection property of all data controls to "Access 2000;" (including
the semicolon).
Quote:
> You have to use DAO3.6 with Access 2000, and it works!
> > You can't use DAO with Access 2000. It requires ADO and almost
> > rewriting your whole program.
> > >Hi,
> > >I have a problem.
> > >My program(in VB6) use Access97 in the past.
> > >Now I convert this database to Access2000 and the program can't open it
> > >anymore. Error says" 3343: Unrecognized database format".
> > >In reference, I have already ticked 'Microsoft Access 9.0 object'.
> > >I use only DAO in my program.
> > >Did I miss to do something else?
> > >Thanks
> > >Ken
