Help!!! Hyperlinks making me crazy

message from =?Utf-8?B?VGVyZXNh?= on 19 May 2004

Does anyone know how to get rid of or work around the hyperlink error message?

(The message displays whenever I click on a hyperlink that opens another database. The message is "Hyperlinks can be harmful to your computer and data...". Both the originating database and the database that I'm trying to open have been digitally signed by a trusted source.)

I am going crazy trying to solve this. I need the database to open another database -- is there a way other than the hyperlink approach?

Thanks for your help.

ReferenceMan replied to =?Utf-8?B?VGVyZXNh?= on 19 May 2004

Well, there are several ways to open another database
from the currently opened.
Dim strFileName as string
strFileName = "C:\SomeNewDatabase.mdb"

SendKeys "{F11}%FO" & strFileName & "{enter}"

If you need to open it as a new instance of the Access,
you can use the Shell Command:

dim strAccessPlusFileLocation as string
strAccessPlusFileLocation = "C:\Program Files\Microsoft
Office\OFFICE11\msaccess.exe C:\SomeNewDatabase.mdb"

X = Shell("C:\Program Files\Microsoft Office\OFFICE11
\msaccess.exe C:\SomeNewDatabase.mdb")

Note: your msaccess.exe and somenewdatabase location may
be different from the one on the example.

You can also try this:
Dim accApp As New Access.Application
accApp.OpenCurrentDatabase ("C:\SomeNewDatabase.mdb")
accApp.Visible = True

But it did not worked for me.

Hope, it helps.

ReferenceMan

hyperlink error message?
that opens another database. The message is "Hyperlinks
can be harmful to your computer and data...". Both the
originating database and the database that I'm trying to
open have been digitally signed by a trusted source.)
database to open another database -- is there a way other
than the hyperlink approach?

=?Utf-8?B?VGVyZXNh?= replied to ReferenceMan on 20 May 2004

Thank you so much!!

I tried each of your suggestions and the last one worked the best for me. I couldn't get the first one to work at all.

I'm still having some problems though -- like the database that I open using your method is minimized, which will be confusing to my users. Perhaps I can work around this too, but I keep thinking there must be an easier way. I'm now searching for work-arounds to my work-arounds all because Access is generating a warning message that will scare my users and yet it's not even applicable in my situation!!

Does anyone know anything about the "dangerous hyperlinks" warning message?

I have emailed Microsoft but have received no response. I really think this is a bug in Access...

Archived message: Help!!! Hyperlinks making me crazy (Microsoft Access)