Using Functions from other Databases

[pcatton@gmail.com]

I have the situation where I have a lot of large databases that use a
lot of the same functions. These prove very difficult to maintain and
so I was wondering if anyone knew if it is possible to use external
database functions. I know this is possible in the VBA code using
references and whilst this is good what I would really like to be able
to do is use external functions in queries as well. The only way I
have found of doing this is to create a local module with the list of
functions that then point to another database but this is not ideal. I
would be grateful for any ideas!

[Tom van Stiphout]

Re: Using Functions from other Databases

On Tue, 8 Apr 2008 05:50:59 -0700 (PDT), pcatton@gmail.c om wrote:

This is exactly what add-ins are created for.
-Tom.

>I have the situation where I have a lot of large databases that use a
>lot of the same functions. These prove very difficult to maintain and
>so I was wondering if anyone knew if it is possible to use external
>database functions. I know this is possible in the VBA code using
>references and whilst this is good what I would really like to be able
>to do is use external functions in queries as well. The only way I
>have found of doing this is to create a local module with the list of
>functions that then point to another database but this is not ideal. I
>would be grateful for any ideas!