Access 2003, turn off macro warnings - help please

[BigMrC]

I have a screen on my main database that has command buttons which open
up various other mdb Access databases. All databases are in the same
folder on each person's C-drive within the network, but the folders
aren't called the same thing. The way I found before to open up a
database from a command line was to use a hyperlink as you don't have
to specify the folder name if it's within the same folder.
With Access 2003 it brings up constant security warnings when using
hyperlinks to access other databases (even with macro security set to
low)
So what is the alternative code for opening another mdb database within
the same folder on C drive without specifying the folder name?
Or
How do you disable these hyperlink security warnings?
thanks

 

[Paul Overway]

Welcome to the bleeding edge. I brought this up during beta, and AFAIK,
there is no cure for this. You could create a command button and use
FollowHyperlink to get around it. It really is stupid...they allow
FollowHyperlink, which is hidden from the user, but put up warnings from
visible hyperlinks.

 

[Van T. Dinh]

CurrentProject.Path gives the pathname of the directory the database is
in. For example:

?CurrentProject.Path
I:\MyAccess2K\A2KDatabases


"I:\MyAccess2K\A2KDatabases" is the directory where my database is stored.