problem using Access 2000 database with VB 6.0 app

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nicholas Couch (blake_at_thecouches.net)
Date: 03/31/04 

Date: 30 Mar 2004 21:35:17 -0800

I am working with a VB 6.0 application that I inherited, and which
currently runs with an Access 97 database and uses DAO code. I need to
have the application start using the same database converted to Access
2000, but when I try to do this I get the "3343 Unrecognized Database
Format" error on a form that uses the Microsoft data control.

I've looked at a number of threads that relate to this particular
scenario, and as far as I can tell, I have followed every feasible
suggestion offered to fix this problem. I have changed the project
references to DAO 3.6 from DAO 3.51. I have tried to update the
Connect property of the data control from "Access" to "Access 2000,"
but when I do this I get a runtime error message about a missing
installable ISAM.

I have yet to find anything that makes this combination of tools work
together properly. Rewriting the application to use ADO instead of DAO
is really not an option. Has anybody had any success making this
scenario (I've got to believe it's a fairly common one) work?

Thanks in advance for all useful advice!

Relevant Pages

  • Re: problem using Access 2000 database with VB 6.0 app
    ... currently runs with an Access 97 database and uses DAO code. ... scenario, and as far as I can tell, I have followed every feasible ... I have yet to find anything that makes this combination of tools work ...
    (microsoft.public.vb.database.dao)
  • Re: Import Text with existing schema.ini file utility
    ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
    (microsoft.public.access.modulesdaovba)
  • Re: Run action query in back-end from front-end database
    ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
    (microsoft.public.access.externaldata)
  • Re: Dao350.dll unsupported under Windows 7
    ... Jet 4.0 is that we have many customers now using our app with DAO 3.51 ... standard user account in Windows to ensure none of the Sandbox ... tried one of our menu commands: Compact Database. ... CloseDB, didn't close the db and left an ldb file lying around. ...
    (microsoft.public.vb.general.discussion)
  • Re: problem using Access 2000 database with VB 6.0 app
    ... currently runs with an Access 97 database and uses DAO code. ... scenario, and as far as I can tell, I have followed every feasible ... I have yet to find anything that makes this combination of tools work ...
    (microsoft.public.vb.database.dao)