access2000和accessxp的区别我想只有微软知道
内部技术我们不可能知道,替换成你的数据库路径和密码就可以连接有密码的数据库
Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Set cnn1 = New ADODB.Connection
cnn1.Open "provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Jet OLEDB:Database Password=1111"Set rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from 11", cnn1Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
内部技术我们不可能知道,替换成你的数据库路径和密码就可以连接有密码的数据库
Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Set cnn1 = New ADODB.Connection
cnn1.Open "provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Jet OLEDB:Database Password=1111"Set rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from 11", cnn1Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
解决方案 »
- ▲▲▲▲▲▲▲▲▲▲谁能做出这道题?▲▲▲▲▲▲▲▲▲▲
- 最大600M免费空间可以申请了,需要者尽快哦。
- 请问哪位能教教俺怎么实现判断本机是否连接局域网内的另一台服务器上?
- 请教如何可实现打开一个扫描文件(ACdsee或别的扫描文件浏览器)
- 求教一个根据asc码实现汉字显示的方法
- StatusBar+进程条问题
- 求救于一条SQL语句,100分求救!!!---关于表的连接
- 100分求winsock的例子!一定要能用好用呀!大哥们救命呀!
- ***********手工安装MSDN***********可以吗?怎么做?**UP有分**
- 如何得到一个不会重复的随机数,比如从1到54,怎么样排列?
- 怎样用ado建立表?(使用sqlsever)
- 简单问题,一句话便成!
Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Set cnn1 = New ADODB.Connection
cnn1.open "Data Source=C:\Documents and Settings\Administrator\桌面\Demo\test.mdb;Extended Properties=';pwd=1111';Persist Security Info=True"
Set rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from 11", cnn1Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
"Dbq=" & Server.MapPath(".") & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"
%>This assumes the MDB is in the same directory where the ASP page is running.
Also make sure this directory has Write permissions for the user account.
If you don't know the path to the MDB (using VB)oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & App.Path & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"This assumes the MDB is in the same directory where the application is running.