gsDatabase = "D:\Documents and Settings\Administrator\桌面\NewFullText\FDFullTextDatabase.mdb"
gsConnect = "ms access;pwd=yuanguanyuan"
Set Dbs = DBEngine.Workspaces(0).OpenDatabase(gsDatabase, False, False, gsConnect)
ADO:
Option Explicit
Dim conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Private Sub Form_Load()
rst.Open "Select * from users", "DBQ=" & "D:\Inetpub\wwwroot\Password\_database\passwords.mdb" & ";Driver={Microsoft Access Driver (*.mdb)};UID=;PASSWORD=Xpass", 3, 1
End Sub