Hyperlink to secured database

[damian]

I'm attempting to use the contents of a combo box to direct staff to certain files on our network. I've used the following code:

Application.FollowHyperlink Me.Combo41, , True, True

It works a treat but I'm unable to link to a secured database. It's straight forward with a MS word file. For example in the combo's underlying table I simply input - X:\FORMS\Form2.doc

With a secured database you have the following to incorporate into the table:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "X:\The Database.mdb" /WRKGRP "X:\Assessments\Secured.mdw"

Any ideas??

 

[ghudson]

Are you just trying to open the secured db from a command button in another db?

If so, use the shell command...

Call Shell("C:\Program Files\Microsoft Office\Office\Msaccess.exe /wrkgrp X:\Assessments\Secured.mdw X:\The Database.mdb", vbNormalFocus)

 

[damian]

No, I'd like to incorporate it into the drop down list of the existing combo box to keep it all consistent.

If all else fails I can use your code (thanks) to put a button on the same form to open the database.