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. 

Beg pardon?  Access 2010 supports database passwords, though not user-level security.

@Dirk... Yes, you are correct however, in reading the question that was not the impression of security the OP was asking about.  Bad wording on my part!

Hi

I am a developer

I built a access file with my password at accdr format and I need to open it by another accdb access file from other location so I need a vba code that it do this

is there anyway?

if NOT , is there anyway to open a accdb file with database password by another accdb access file from other location, but in runtime mode?

if Not, is there anyway to open a accdr file with database password by another accdb access file from other location?

regard

Have you tried using

Dim strPath As String

strPath = "YourPathToTheDatabaseIncludingFileNameAndExtensionHere"

Application.FollowHyperlink strPath

Hi dear

Thanks for your reply

ok , it's work correctly but a message appears with this message :

" some files can  contain viruses or otherwise be harmful ...

.......... would you like to open this file? "

I have 2 question now :

1-how can omit that message?

2-How can open accdr file that I want to open with this code , when it has a database password ?

Note: I don't want to use of sendkeys command for this purpose

regard