Hello Experts,

I have the following situation:
ACCESS 2002
Client DB with linked tables to BE_DB holding all tables and a lot of
code.

In the BE_DB I have some Functions which process data.

I want to call a function stored on the BE_DB and return the result to
the caller (Client).
This would prevent me to maintain a lot of code in Client and BE_DB
which is actually identical.

I Imagine I could crate a paramter query on the BE_DB which calls the
function as part of an SQL statement and return the result as a field.

Probably I can somhow call this query / procedure from my client and
receive the result.

Is there any standard way to execute such a task ?


Thanks a lot

Rolf