vb连接Access问题

来源:百度知道 编辑:UC知道 时间:2024/06/01 02:40:54
程序只能连接access95,不能连接2000版本,总是提示"不可识别的数据库"
哪位高手帮忙改下,让这个程序可以读取access2000

另外在读取大量数据时总是显示"参数不足"望高手指点

' Export the file.
Private Sub cmdExport_Click()
Dim fnum As Integer
Dim file_name As String
Dim database_name As String
Dim db As Database
Dim rs As Recordset
Dim num_fields As Integer
Dim field_width() As Integer
Dim field_value As String
Dim i As Integer
Dim num_processed As Integer

On Error GoTo MiscError

' Open the output file.
fnum = FreeFile
file_name = txtFileName.Text
Open file_name For Output As fnum

' Open the database.
Set db = OpenDatabase(txtDatabaseName.Text)

' Open the recordset.
Set rs = db.OpenRecordset( _
"SELECT * FROM Books ORDER BY Title")

' Start with the names of the fields.
num_fields = rs.Fields.C

(1)你可以换种连接方式
用ADODB连或adodc控件
(2)在Access里把数据库转化成access97
打开ACCESS 菜单栏上选工具——数据库实用工具——数据库转化
只有这两种方法了吧 呵呵

建议直接用adodc控件直接连接