Dim sConnect As String
Dim sSQL As String
Dim dfwConn As ADODB.Connection
Dim RS As Recordset
ADO的例子
sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\YourDB.mdb;"
sSQL = "* FROM YourTable where ……"
Set dfwConn = New Connection
dfwConn.Open sConnect
Set RS = New Recordset
RS.CursorLocation = adUseServer
RS.Open sSQL, dfwConn, adOpenDynamic, adLockReadOnly, 1
Dim sSQL As String
Dim dfwConn As ADODB.Connection
Dim RS As Recordset
ADO的例子
sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\YourDB.mdb;"
sSQL = "* FROM YourTable where ……"
Set dfwConn = New Connection
dfwConn.Open sConnect
Set RS = New Recordset
RS.CursorLocation = adUseServer
RS.Open sSQL, dfwConn, adOpenDynamic, adLockReadOnly, 1
解决方案 »
- 谁介绍本关于VB2005+ACCESS的数据库应用的书?
- 关于VB的学习方法~~
- 怎么用一个winsock控件(udp协议)实现收发信息
- 关于水晶报表错误“用户定义类型未定义”
- 通过代码添加的控件如何删除掉?
- 高手问题。如何让数据库与程序一起编译生成一个可执行文件?
- 有没有办法把一个字符串变量当变量??
- 怎么给string变量,加入回车换行字符?c++里是\r\n.VB怎么办?100分,立马给
- 请问:vb中开发中间层Com+组件的标准过程是怎样的?
- !!!送分题:如何将treeview与数据库链接?!(一定给分)
- 请问高手,这两段程序执行结果为什么不一样?(程序很短,很简单)
- 关于数组的一个问题
Dim WS As Workspace
Dim DB As Database
Dim RS As Recordset
Dim SQL As String
SQL = "SELECT * FROM YourTable where ……"
Set WS = CreateWorkspace("", "admin", "", dbUseJet)
Set DB = WS.OpenDatabase("f:\WORK\zls\ZLS.MDB", True, True, ";pwd=")
Set RS = DB.OpenRecordset(SQL, dbOpenDynaset)