Can someone help me create a hyperlink to a secured database?
I would like to add a button to a form that, when clicked, will open to a secured database.
At this time, what I have works....sort of.
I have a button with this text in the "Hyperlink Address" property:
\\lmwdbs01\mrdcdata\Shortcut to Preferred Methods.mdb.lnk
When I click the button, I get a Microsoft Office which I'm assuming is a security message becasue it states that "some files may contain viruses" and verifies that you want to open it. This message is ok and I can understand the reason for it.
After I click the "yes" to say I do want to open it, a "Move Items" box opens asking me where I want to move "Shortcut to Preferred Methods.mdb". I click Cancel and it pops up again. I click Cancel again and it goes right into the sign on screen for the secured database. I can sign in and open then.
How do I eliminate the "Move Items" boxes?
I also tried using the Call Shell in VB but that didn't work either.
Here is the full path of the shortcut:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\lmwdbs01\mrdcdata\Preferred Methods.mdb" /WRKGRP "\\lmwdbs01\mrdcdata\Secured.mdw"
I am using Access 2007 and Windows XP.
Thank you in advance.
I would like to add a button to a form that, when clicked, will open to a secured database.
At this time, what I have works....sort of.
I have a button with this text in the "Hyperlink Address" property:
\\lmwdbs01\mrdcdata\Shortcut to Preferred Methods.mdb.lnk
When I click the button, I get a Microsoft Office which I'm assuming is a security message becasue it states that "some files may contain viruses" and verifies that you want to open it. This message is ok and I can understand the reason for it.
After I click the "yes" to say I do want to open it, a "Move Items" box opens asking me where I want to move "Shortcut to Preferred Methods.mdb". I click Cancel and it pops up again. I click Cancel again and it goes right into the sign on screen for the secured database. I can sign in and open then.
How do I eliminate the "Move Items" boxes?
I also tried using the Call Shell in VB but that didn't work either.
Here is the full path of the shortcut:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\lmwdbs01\mrdcdata\Preferred Methods.mdb" /WRKGRP "\\lmwdbs01\mrdcdata\Secured.mdw"
I am using Access 2007 and Windows XP.
Thank you in advance.
