access| Error | data | Database The information in this article applies to: Microsoft Visual Basic Professional Edition for Windows 5.0, 6.0 Microsoft Visual Basic Ente Rprise Edition for Windows 5.0, 6.0 Microsoft Access Microsoft Data Access Components 2.5, 2.6 The publication number of this article was once a CHS238401 symptom when you When you try to access an Access 2000 database from a Visual Basic program, you may experience one of the following errors:
If you are using an ADO (or ADO Data Control):
Run Error:-2147467259: Database format is not recognized if you use DAO (or DAO General Data Control):
Run Error: 3343: Database format Unrecognized reason Access 2000 uses the Jet 4.0 engine, which creates a Jet 4.0 format database file. This format is not recognized by the Jet 3.5 component. If you use ADO and you try to connect Access 2000 through the Microsoft Jet OLE DB 3.51 provider, you get an error message-2147467259. If you use DAO and you use the Microsoft DAO 3.51 Object Library, you get the 3343 error message above. DAO generic data controls cannot work with Access 2000 databases and always produce 3343 errors, but you can avoid errors by following the instructions in the workaround section of this article. The error occurs because the control is based on Jet 3.51 and therefore can only identify the database format of Jet 3.51 (or previous version). Solution to resolve this problem, use any of the following methods:
Install Visual Studio Service Pack 4. For an ADO (or ADO Data Control), use the "Microsoft.Jet.OLEDB 4.0" provider. For DAO, go to the Project menu and select a reference to use the Microsoft DAO 3.6 Object Library. If you are using a generic data control, you need to open a DAO 3.6 recordset and designate it as the source for the data control, as follows:
Option explicitprivate daoDB36 as Databaseprivate rs as DAO. RecordsetDim spath as Stringprivate Sub form_load () spath = _ "C:\Program Files\Microsoft Office\Office Amples\ Northwind.mdb "Set daoDB36 = DBEngine (0). OpenDatabase (spath) Set rs = Daodb36.openrecordset ("Customers") Set data1.recordset = Rsend Sub
The problem has been resolved in Visual Basic Service Pack 4, and the new value (Access 2000) is added to the connection properties, and the DAO data control opens the Access 2000 database. State Microsoft has resolved this problem in Visual Basic Service Pack 4, adding the new value (Access 2000) to the Connection property, and the DAO data control opens the Access 2000 database. To obtain Visual Studio Service Pack 4, visit the following Web site:
Http://msdn.microsoft.com/vstudio/sp refer to the Access 2000 documentation for more information about Jet 4.0.
For more information about ADO and DAO, see your Visual Basic documentation.
For more information about the unrecognized database format, consult the appropriate topic in the MSDN Library that is included with Visual Basic.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
