"SELECT * FROM L:\DATA.mdb.admin.[密码].表"不行啊! 它只会把 "L:\DATA.mdb.admin.[密码]"当成一个文件名 提示:找不到文件
那只能这样了 dim Cn as new ADODB.Connection cn.open "......连接字符串","admin","密码" dim Rs as new Adodb.RecordSet rs.open "select * from table1",cn
SELECT c.*, o.* FROM Northwind.dbo.Customers AS c INNER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders) AS o
SELECT * FROM L:\DATA.mdb.admin.[你的密码].表
它只会把 "L:\DATA.mdb.admin.[密码]"当成一个文件名
提示:找不到文件
dim Cn as new ADODB.Connection
cn.open "......连接字符串","admin","密码"
dim Rs as new Adodb.RecordSet
rs.open "select * from table1",cn
FROM Northwind.dbo.Customers AS c INNER JOIN
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)
AS o
但在VB的查询中就根不识别"OPENROWSET()"!
'连接带密码的ACCESS数据库中:
Dim cn As ADODB.Connection
Dim StrConnect As String
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & App.Path & "\youDB.mdb;Persist " _
& "Security Info=False;Jet OLEDB:Database Password=abc"
Set cn = New ADODB.Connection
cn.Open StrConnect
“SELECT * FROM 表1, L:\DATA.mdb...表2[.....]”
同时访问两个以上相同格式数据库,更可以改一改
就可以变成对两数据库之间操作。
怎样用VB实现:撤销mdb数据库密码,及添加密码?
但在VB的查询中就根不识别"OPENROWSET()"!
==========================================
不会吧,我在用好象可以,不过没试过访问acess
select a.*, b.*
from tb as a, [;database=e:\a.mdb;pwd=123].tb as b;