Access 2003 hyperlink problem - help!!

[RTC]

Just upgraded to Access 2003 - every time you click on a button assigned to a hyperlink (to another database within the same folder) it comes up with a security warning:

"Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted sources. Do you want to continue" Yes/No

How do you get rid of these? I have hundreds of hyperlink buttons on my databases and it would be a nightmare to role Office 2003 out with these constantly popping up.

Thanks

 

[Calvin]

Why are you using a hyperlink to open another mdb file?

Probably better off using:

Shell "msaccess.exe  c:\folder1\sample.mdb",1

You may get limited feedback for Access 2003 as most users havn't been exposed to it yet, but from what I understand the only major changes to it are security related.

Keep us up to date with your experiences.

 

[RTC]

I can't get that command to work. For info have one main Access db and several other smaller ones. They are all in the same folder on each of our computers but not all folders have the same name. So in the hyperlink I just have, "Database 1.mb" for instance and it defaults to looking for this in the same folder so doesn't matter what the name of the folder is. The command you've given looks like you have to specify the folder name?
I tried it with the following on click command of the button (trying to open a db called "CATS IT")

Shell "msaccess.exe c:\CATS_SQL_MDB\CATS IT.mdb", 1

and it comes back with something about the command line you used to open microsoft access contains and option that Access doesn't recognize and nothing happens.

Is there a way of opening mdb databases within the same folder using on click command of a button, without specifying folder name, assuming nobody has answer to hyperlink security message?

 

[Rats]

I know this is a little late for the original query but I found this answer on the MS site that may help others in the future with this problem. The fix involves a change to a registry key

http://support.microsoft.com/?kbid=829072

 

[sapala]

how it works, if i want to open .pdf files, some are in same folder. I hate this message
.pdf files aren't in internet