User Defined Function

[henrymci]

I have a query setup in an Access Database that I would like to call
from one of my ASP pages. When I try to set up the database results
area using this query as the source I get the error below.

[Microsoft][ODBC Microsoft Access Driver] Undefined function
'paddigits' in expression.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

The paddigits function is user defind in a module in the Access
database. How can I define this UDF in FrontPage so I can call the
query that uses this function?

 

[Kevin Spencer]

You can't. What you *can* do is to create a Stored Query in Access that uses
the function, and then call that Stored Query (SELECT * FROM
StoredQueryName) in your Database Results.

--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Shooter
http://unclechutney.blogspot.com

A man, a plan, a canal, a palindrome that has.. oh, never mind.