Hi,

Can anyone help me on how to,

how to open a secured Access 2003 Database with Workgroup User ID and Password via Automation. Search through the internet and found the below example BUT only for password only.

' Open a password-protected database in shared mode
' Note: The bstrPassword argument is case-sensitive
oAccess.OpenCurrentDatabase(filepath:="c:\mydb.mdb", _
Exclusive:=False, bstrPassword:="MyPassword")

Thanks in advance.:D