[Microsoft][ODBC Microsoft Access Driver] Undefined function

[Rasta]

Hi,

I have an Access 2000 database that I connecting to from an asp page. The
query I am running from the page is an Access query that contains some
public functions that I wrote in a standard module. I am getting an error
because the query uses these functions. If I convert to a later version of
Access will this resolve this problem or is there some other way to address
it without taking the functions out of the query?

thanks

 

[Dirk Goldgar]

Hi,

I have an Access 2000 database that I connecting to from an asp page.
The query I am running from the page is an Access query that contains
some public functions that I wrote in a standard module. I am
getting an error because the query uses these functions. If I convert
to a later version of Access will this resolve this problem or is
there some other way to address it without taking the functions out
of the query?

Unfortunately, user-written VBA functions are only recognized when the
query is run from Access. Converting to Access 2002 or 2003 won't solve
this problem. The only workaround I can think of is to remove the
functions from the queries, define them in the VBScript of your ASP
page, and call them from the server. This may mean breaking up a single
query into separate queries, and then combining the results in the
server code while applying the VBScript implementations of the
functions.

 

[Rasta]

That's what I feared would be the case - thanks for your reply