如何访问有密码的ACCESS数据库?
ciby 2002-04-25 02:53:59 在VB里如何打开有密码的ACCESS数据库?我这样设置连接方式访问不行:
Dim rs As adodb.Recordset
Dim MyConn As adodb.Connection
Dim strConn As String
Set MyConn = New adodb.Connection
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\监管系统\综合检测\inspect.mdb;Jet OLEDB:Database Password=1230"
MyConn.Open ConnectionString:=strConn
Set rs = New adodb.Recordset
sql = "select * from area"
rs.Open sql, strConn, adOpenStatic, adLockReadOnly
Set Grid.DataSource = rs
结果它既不报错也没有显示数据出来,怎么回事?