Data控件不能直接支持ACCESS 2000格式的数据库文件。解决方法: '引用DAO 3.6 dim db as database, rs as recordset set db = dbengine.open("d:\oa works\data\file_table.mdb") set rs = db.openrecordset("yourtable") set data1.recordset = rs
如果你用的是access2000,把他转换成97试试。
我已经用了97,Data1.DatabaseName = "d:\oa works\data\file_table.mdb"提示不可识别的数据库格式的问题已经解决了, 但是又出现了 Dim db As Database, rs As Recordset Set db = DBEngine.OpenDatabase("d:\oa works\data\file_table.mdb") Set rs = db.OpenRecordset("file_table1") Set Data1.Recordset = rs 中的Set rs = db.OpenRecordset("file_table1")的数据类型不匹配的问题。 如何解决?
'引用DAO 3.6
dim db as database, rs as recordset
set db = dbengine.open("d:\oa works\data\file_table.mdb")
set rs = db.openrecordset("yourtable")
set data1.recordset = rs
但是又出现了
Dim db As Database, rs As Recordset
Set db = DBEngine.OpenDatabase("d:\oa works\data\file_table.mdb")
Set rs = db.OpenRecordset("file_table1")
Set Data1.Recordset = rs
中的Set rs = db.OpenRecordset("file_table1")的数据类型不匹配的问题。
如何解决?