A family of Microsoft relational database management systems designed for ease of use.
Have you tried using
Dim strPath As String
strPath = "YourPathToTheDatabaseIncludingFileNameAndExtensionHere"
Application.FollowHyperlink strPath
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi dear
how can I open accdr file protected with database password by another one accdb file (with VBA code) ?
regard
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
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
@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!
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.
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?