open accdr file protected with database password

Since there is no *security* in an Access 2010 databases you must have put your own, stored in some table.  I don't have any VBA for that.  Below is code the used to work on Access 2003 and down.  You might be able to modify that...

 

http://www.access-programmers.co.uk/forums/showthread.php?t=178072

Hi dear

can you give me a way with stored password in some table for the purpose ?

regard

Not really sure what you're asking for, so hopefully this will help...

http://www.access-diva.com/f10.html

You never answered my question:  Are you trying to open the database in a second instance of the Access application, or are you just trying to read data from it?

If you want to open it in a second instance of Access, you could do something like this:

    Dim oAccess As Access.Application

    Set oAccess = New Access.Application

    oAccess.OpenCurrentDatabase "YourPath\To\OtherDatabase.accdr", False, "ThePassword"

    oAccess.Visible = True

    oAccess.UserControl = True

    Set oAccess = Nothing

That is untested code, but something like it might work.

You never answered my question:  Are you trying to open the database in a second instance of the Access application, or are you just trying to read data from it?

 

If you want to open it in a second instance of Access, you could do something like this:

 

    Dim oAccess As Access.Application

 

    Set oAccess = New Access.Application

 

    oAccess.OpenCurrentDatabase "YourPath\To\OtherDatabase.accdr", False, "ThePassword"

 

    oAccess.Visible = True

    oAccess.UserControl = True

 

    Set oAccess = Nothing

 

That is untested code, but something like it might work.

Hi dear

1- I built a accdb file and another protected accdr file with database password

I want to have a button on a form in the accdb file when I press it ,it open that accdr file (No only read from it )

2- OpenCurrentDatabase method can't open accdr file format.

Hi All

1-if any way with other method like : use of Shell command , will be good

2-boblarson'answer worked correctly for opening accdr file but without password protected

that was :

Dim strPath As String

strPath = "YourPathToTheDatabaseIncludingFileNameAndExtensionHere"

Application.FollowHyperlink strPath

is there any way to add a command to support database password protected accdr file?

regard