Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: The Data Form Wizard May Not Open an Access 2000 Database


View products that this article applies to.

Symptoms

If you use the Visual Basic Data Form Wizard to open an Access 2000 database you may get the following error:
"Unrecognized Database Format '....\your_database_name.mdb'"

↑ Back to the top


Cause

The Visual Basic Data Form Wizard uses the Jet OLEDB 3.5 Provider which does not recognize the Access 2000 database format.

↑ Back to the top


Resolution

Open the Access 2000 database through an ODBC DSN using the Access ODBC driver version 4.0.

-- Or --

Build your form manually using either the Jet OLEDB version 4.0 provider or an ODBC DSN through the Access ODBC driver version 4.0

↑ Back to the top


Status

This is a problem with Visual Basic 6.0 Service Pack 3 and earlier versions. This problem has been fixed in Service Pack 4 for Visual Basic.

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. Start a new Visual Basic project.
  2. Add a new Form using the Visual Basic Data Form Wizard.
  3. Click Next in the Introduction dialog box.
  4. Choose Access in the Database Type dialog box.
  5. Point to Access 2000 in the Database dialog box.
  6. Click Next and you receive the error you saw in the Symptoms section.

↑ Back to the top


References

238401 "PRB: Unrecognized Database Format Error Upgrading to Access 2000"

↑ Back to the top


Article Info
Article ID : 242010
Revision : 3
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 355