CAUSE
Access 2000 uses the Jet 4.0 engine, which creates Jet 4.0 format database files. Jet 3.5 components do not recognize such a format. If you are using ADO, you get error -2147467259 when you try to connect to your Access 2000 through the "Microsoft.Jet.OLEDB.3.51" provider.
If you are using DAO, you get error 3343 above when you use the "Microsoft DAO 3.51 Object Library."
The DAO generic Data-Control does not work against Access 2000 databases, and always generates error 3343 unless used as instructed in the "Resolution" section of this article. This occurs because this control is based on Jet 3.51 and only recognizes Jet 3.51 (or before) database formats.RESOLUTION
To resolve this problem, do one of the following: Install Visual Studio Service Pack 4.
For ADO (or the ADO Data Control), use the "Microsoft.Jet.OLEDB.4.0" provider.
For DAO, go to Project menu, and choose References to use the "Microsoft DAO 3.6 Object Library."
If you use the generic Data-Control, you need to open a DAO 3.6 recordset and then assign it to be the source of the Data Control as follows:Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As StringPrivate Sub Form_Load()
sPath = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs
End Sub
This problem has been addressed by Visual Basic Service Pack 4. A new value (Access 2000) has been added for the Connect property that will allow the DAO Data Control to open Access 2000 databases
Access 2000 uses the Jet 4.0 engine, which creates Jet 4.0 format database files. Jet 3.5 components do not recognize such a format. If you are using ADO, you get error -2147467259 when you try to connect to your Access 2000 through the "Microsoft.Jet.OLEDB.3.51" provider.
If you are using DAO, you get error 3343 above when you use the "Microsoft DAO 3.51 Object Library."
The DAO generic Data-Control does not work against Access 2000 databases, and always generates error 3343 unless used as instructed in the "Resolution" section of this article. This occurs because this control is based on Jet 3.51 and only recognizes Jet 3.51 (or before) database formats.RESOLUTION
To resolve this problem, do one of the following: Install Visual Studio Service Pack 4.
For ADO (or the ADO Data Control), use the "Microsoft.Jet.OLEDB.4.0" provider.
For DAO, go to Project menu, and choose References to use the "Microsoft DAO 3.6 Object Library."
If you use the generic Data-Control, you need to open a DAO 3.6 recordset and then assign it to be the source of the Data Control as follows:Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As StringPrivate Sub Form_Load()
sPath = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs
End Sub
This problem has been addressed by Visual Basic Service Pack 4. A new value (Access 2000) has been added for the Connect property that will allow the DAO Data Control to open Access 2000 databases
为什么不先用查询表限制一下呢
謝謝