创建之后,如何使用,是不是与普通的数据库相同?
如
Dim str As String
Set conn = New Connection
Set rs = New Recordset
sdbname = App.Path + "\english.mdb"
sPassword = ""
str = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
conn.Open str
rs.Open "Select * from 表1", conn, 3
如
Dim str As String
Set conn = New Connection
Set rs = New Recordset
sdbname = App.Path + "\english.mdb"
sPassword = ""
str = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
conn.Open str
rs.Open "Select * from 表1", conn, 3
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货