呵呵,楼上看看清楚,他的连接在内部数据库上,但是外部数据库有密码。
试试:
INSERT INTO [DWZC] SELECT * FROM [DWZC] IN ['" & strApp & "SFGZ.mdb';Jet OLEDB:Database Password=" & strPassword & "] WHERE (" & SqlDwdm & ")"
试试:
INSERT INTO [DWZC] SELECT * FROM [DWZC] IN ['" & strApp & "SFGZ.mdb';Jet OLEDB:Database Password=" & strPassword & "] WHERE (" & SqlDwdm & ")"
ConnString = "driver={Microsoft access driver (*.mdb)};Dbq=tianyin.mdb;uid=;pwd=;defaultdir=" & App.Path & "\data"
系统提示有错(Characters found after end of SQL statement)
zhangbob(bob):
我看不懂,是重新定义一个连接对象吗?
当你需要insert数据的时候,可以调用
sqlInsert = "INSERT INTO...." //你要insert的数据
rs.Open strInsert, conn
而且,我个人觉得你的sql语法有问题!检查一下罗!