Function Cn() As Boolean Dim str As String Cn = False str = "dsn=Warehouse;uid=andyhuang;pwd=1234; " Set conn = New ADODB.Connection On Err GoTo conn_Err
conn.Open str
Cn = TrueExit_Function: Exit Function conn_Err: MsgBox Err.Description, vbOKOnly, "Error" Resume Exit_FunctionEnd Function
SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable
Dim str As String
Cn = False
str = "dsn=Warehouse;uid=andyhuang;pwd=1234; "
Set conn = New ADODB.Connection
On Err GoTo conn_Err
conn.Open str
Cn = TrueExit_Function:
Exit Function
conn_Err:
MsgBox Err.Description, vbOKOnly, "Error"
Resume Exit_FunctionEnd Function
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable