Unrecognized database format

[Todd]

I am trying to write a Visual Basic 6 application to
access an Access 2002 database but I get an "Unrecognized
database format" error message when I try to connect to
the database in my VB6 code. Anyone know the solution to
this problem?

 

[Tony Toews]

I am trying to write a Visual Basic 6 application to
access an Access 2002 database but I get an "Unrecognized
database format" error message when I try to connect to
the database in my VB6 code. Anyone know the solution to
this problem?

To add to Rick Brandt's posting he is correct. VB6 only knows about
Access 97/Jet 3.5 format MDBs. You need to use Jet 4.0 DLLs. There
should be Knowledge Base articles on this topic at
support.microsoft.com.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Douglas J. Steele]

Sorry to disagree with Rick and Tony, but it is possible to use VB6 with
Access 2002: you just need to ensure you have the correct references set.

Check out the following KB articles:

PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or
2002:
http://support.microsoft.com/default.aspx?scid=kb;[LN];238401
FIX: The Data Form Wizard May Not Open an Access 2000 Database:
http://support.microsoft.com/default.aspx?scid=kb;[LN];242010
HOWTO: Modify the Visual Data Manager (VISDATA) to Work with Access 2000
Databases:
http://support.microsoft.com/default.aspx?scid=kb;[LN];252438
FIX: Unrecognized Database Format Error with Data Control or Data Form
Wizard:
http://support.microsoft.com/default.aspx?scid=kb;[LN];257780

 

[Tony Toews]

Sorry to disagree with Rick and Tony, but it is possible to use VB6 with
Access 2002: you just need to ensure you have the correct references set.

Better explanation that mine.

Thanks, Doug

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm