模块:
Public strclid As String
Public cnn As New ADODb.Connection
Public user As String
Sub main()
cnn.Open "driver =microsoft access driver (*.mdb);dbq=" & App.Path & "\..\database\enactus.mdb"
login.Show
End Sub语句,总是显示cnn=“”
rss.Open "select * from user where name ='" & Text1.Text & "'", cnn, adOpenDynamic, adLockOptimistic
不知道是哪里错了……
Public strclid As String
Public cnn As New ADODb.Connection
Public user As String
Sub main()
cnn.Open "driver =microsoft access driver (*.mdb);dbq=" & App.Path & "\..\database\enactus.mdb"
login.Show
End Sub语句,总是显示cnn=“”
rss.Open "select * from user where name ='" & Text1.Text & "'", cnn, adOpenDynamic, adLockOptimistic
不知道是哪里错了……
解决方案 »
- 再发100贴问Dim WithEvents_objfrm As FrmApplyShop
- char tk[6]={0xa0,0xa1,0xa2,0xa3,0xa4,0xa5}; vb中如何改写
- 如何跨工程调用窗体?
- 急:用 setup factory 制作的安装包一运行 就先提示“setup has detected that your Microsoft Visual Basic 6.0 run-time files are ou
- 偶要离开了,散分。。。
- 如何得到文本框的行数?
- 多表查询中出现的错误(ACCESS)??
- BMP相关格式数据
- 39分求救!!如何得到字符串的首地址??
- 晚上好!!!VB 能编驱蚊子的程序吗?
- VBA终止用户的删除行/列操作
- lisp中的原子是否是指针
Sub main(cnn)
cnn.Open "driver =microsoft access driver (*.mdb);dbq=" & App.Path & "\..\database\enactus.mdb"
End Sub '这个过程必须在模块或在当前界面,否则这个数据库连接会丢失。'在调用数据库连接的界面,必须有
Dim rss As New ADODB.Recordset '声明
Call main(cnn) '调用数据库连接
rss.Open "select * from user where name ='" & Text1.Text & "'", cnn, adOpenDynamic, adLockOptimistic
'这样就不会出错了。