Can I use a stored proceedure with a custom built function in it?

[JGKWORK]

Hi,

I have a stored proceedure in an Access DB (a query). One of the fields in the query refers to a custom built function which sits in a module within Access.

I have a call to this stored proceedure in an ASP page. It works fine if I DON'T use the in built function in my query but if I do it doesn't work.

The question is: Is there a way to call and use a query in Access which has a CUSTOM BUILT FUNCTION in it?

Many thanks.....

 

[dhookom]

You can't reference a user-defined Access function in a Stored Procedure. Many Access creatable function can be written as functions in SQL Server.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[JGKWORK]

Thanks, sorry not 100% understanding, does that mean I could create a user defined function in SQL Server and it would work?

Thanks again.