PDA

View Full Version : Open protected Access database file in Excel



dc2000
03-04-2008, 09:59 PM
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?

Set oApp = CreateObject("Access.Application")
oApp.SetDefaultWorkgroupFile "workgroup_file.mdw"
oApp.OpenCurrentDatabase "database_file.mdb"

Trevor
03-14-2008, 01:44 PM
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{+}