药物过敏应急预案照片:vb连接本地mbd数据库的语句怎么写啊!

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 06:52:20

Dim Con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Sql As String

Set Con = New ADODB.Connection
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=你的数据库地址;Persist Security Info=False"
Set rs = New ADODB.Recordset
rs.Open "Select * From 表", Con, adOpenDynamic, adLockOptimistic