基本情况: 在VB下开发的时候使用的是Access97
但客户的机器上已经安装了Access2000.
(安装时携带Access97数据库) 出现的错误:
Can't open a database created with a previous version of your application.
请问如何解决?
谢谢!
但客户的机器上已经安装了Access2000.
(安装时携带Access97数据库) 出现的错误:
Can't open a database created with a previous version of your application.
请问如何解决?
谢谢!
转换数据库为Access2000
Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False"
CN.Open Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic Set DataGrid1.DataSource = Rs
是不可以转为Access2000,又出现别的问题了。
我的代码是xPath = App.path '设置Access数据库
If Right(Trim(xPath), 1) <> "\" Then
xPath = xPath + "\"
End If
'Data_User.Connect = xPath & "smsbill.mdb"
Data_User.DatabaseName = xPath & "smsbill.mdb"
Data_User.RecordSource = "user"
Data_User.Refresh
有什么问题吗?谢谢!
我的代码是xPath = App.path '设置Access数据库
If Right(Trim(xPath), 1) <> "\" Then
xPath = xPath + "\"
End If
'Data_User.Connect = xPath & "smsbill.mdb"
Data_User.DatabaseName = xPath & "smsbill.mdb"
Data_User.RecordSource = "user"
Data_User.Refresh
有什么问题吗?谢谢!
添加以下代码:Dim db As DAO.database, rs As DAO.RecordsetSet db = DBEngine.OpenDatabase(xPath & "smsbill.mdb")
Set rs = db.OpenRecordset("user")
Set Data1.Recordset = rs