我想用vb访问access2000,用如下代码,但是怎么也不能运行,请指点指点,谢谢
Dim conn As New ADODB.Connection
Dim rec As New ADODB.Recordset
Dim cmd As New ADODB.Command
Dim strSql As String
Dim strcnn As StringstrSql = "select * from user"
strcnn = "uid=qhz;pwd=;DRIVER={ Microsoft Access Driver (*.mdb) };DBQ=" & App.Path & "\user.mdb"
Set conn = New ADODB.Connection
conn.Open strcnn
Set rec = New ADODB.Recordset
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = conn
cmd.CommandText = strSql
Set rec = cmd.Execute如果愿意,请给我发一段能运行的代码,谢谢
Dim conn As New ADODB.Connection
Dim rec As New ADODB.Recordset
Dim cmd As New ADODB.Command
Dim strSql As String
Dim strcnn As StringstrSql = "select * from user"
strcnn = "uid=qhz;pwd=;DRIVER={ Microsoft Access Driver (*.mdb) };DBQ=" & App.Path & "\user.mdb"
Set conn = New ADODB.Connection
conn.Open strcnn
Set rec = New ADODB.Recordset
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = conn
cmd.CommandText = strSql
Set rec = cmd.Execute如果愿意,请给我发一段能运行的代码,谢谢
解决方案 »
- 串口接收数据不完整
- 如何使程序执行完外部程序后,再执行后面的代码
- VB工程如何共享一个Access数据库?
- 怎样实现sql+ado 远程连接?不用手工配置ODBC
- 呵呵,这么晚了还有这么多人和我一样在工作,战友们加油干呀。内有两个问题
- ADO Update时的E_FAIL问题
- 请问怎么使用autocad控件
- 兄弟们help me
- 谁知道outlook和友情强档左边的能拉上拉下的菜单怎么做的
- com通信问题
- 一家喜欢用VB6+SQL2k+Win2K的 公司要我面试,好不容易的机会,不知道要准备点什么知识,时间不多了!急急急!学4年VB了,高程早上的基础
- 关于时间的sql语句的问题,我用dtpicker,数据库中的数据为2003-3-15 00:00:00,
Dim rec As New ADODB.Recordset
Dim cmd As New ADODB.Command
Dim strSql As String
Dim strcnn As String'我在我的机上调试时,出现了表名不能用user的错误,将表名改为userinfo后调试正常
strSql = "select * from userinfo"
strcnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\test\user.mdb;Persist Security Info=False"
Set conn = New ADODB.Connection
conn.Open strcnn
Set rec = New ADODB.Recordset
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = conn
cmd.CommandText = strSql
Set rec = cmd.Execute
http://www.sijiqing.com/vbgood/tools/index.asp?action=read&id=51
strSql = "select * from [user]"