open accdr file protected with database password

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

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

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

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

Have you tried using

Dim strPath As String

strPath = "YourPathToTheDatabaseIncludingFileNameAndExtensionHere"

Application.FollowHyperlink strPath

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