try like this:
Set dbs = DBEngine.OpenDatabase("C:\my.mdb", False, False,
";pwd=mypassword")

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> Getting difficulty to open a password protected database from another
> Access
> file via VBA. Please help