Open protected Access database file in Excel

[dc2000]

Hi everyone:


I'm trying to open a protected Access database file. I have an MDB file, also MDW file and USER NAME and PASSWORD.

Is it possible at all?

So far I came up with this, but where do you put user name and password?
[vba]
Set oApp = CreateObject("Access.Application")
oApp.SetDefaultWorkgroupFile "workgroup_file.mdw"
oApp.OpenCurrentDatabase "database_file.mdb"
[/vba]

[Trevor]

run code to see when you are pompted for username and password
then sendkeys "username"{Enter} ' username is the user name you would type
and make aptopriat changes for password
if you need to capitalize a letter use +(follwed by letter)
if you need to send "+" then use{+}