Unrecognized Database Format Error Message with Access 2000 Databases

Unrecognized Database Format Error Message with Access 2000 Databases

The standard DAO Data control is designed to work with the Jet 3.5 Engine, whereas Access 2000 database can be accessed only by the more recent Jet 3.6 engine. For this reason, any attempt to access an Access 2000 database using the standard DAO Data control, as well as regular DAO commands, is doomed to failure and will raise run-time error 3343 “Unrecognized Database Format”.

The only way to work around this issue is to open manually the database using the Microsoft DAO 3.6 Object Library, instead of the older Microsoft DAO 3.51 Object Library. If you are working with a Data control you can open the desire Recordset and assign it to the Recordset property of the Data control, as in:

' this code assumes that you added a reference' to the Microsoft DAO 3.6 Object LibraryDim db As Database, rs As RecordsetSet db = DBEngine.OpenDatabase("c:datayourdb.mdb")Set rs = db.OpenRecordset("TableName")Set Data1.Recordset = rs

If you’re accessing the Access 2000 database using ADO or the ADO Data control, you can get a run-time error -2147467259 “Unrecognized Database Format” if you use the Microsoft.Jet.OLEDB.3.51 provider, which is the OLEDB provider that is automatically installed with VB. You can fix this error by simply upgrading to the Microsoft.Jet.OLEDB.4.0 provider.

See also  What Are International Payments, And How Do They Work?

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist