Error calling MS-Access Module Function from SQL

[Bob Barrows]

Lars wrote:

> Hi
>
> We are using an MS Access DB for basic information such as
> user logins and products/rates. The rate calculations are
> based on table information that is processed with a
> multitude of parameters in an Module/Function.
> For easier understanding imagine this:
> EXAMPLE:
> SELECT fnRate(@Param1, @Param2) AS Rate FROM Rates
> PUBLIC FUNCTION fnRate(@Param1, @Param2) AS Currency
>
> This methology works great within Access itself, however
> fails with "UNDEFINED FUNTION fnRATE" - ERROR JET Database

Unfortunately, user-defined procedures in an Access module are only
accessible when Access is running. There are security ramifications that
prompted MS to prevent external applications (such as ADO) from running
them.

There are other builtin VBA functions that are also prevented from running
unless Access is involved. They are listed here:
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;239482[/url]

Sorry,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bullschmidt]

That's right. ASP pages can "see" Access tables and queries but that's
about it.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!