Calling an SQL UDF from Access 97

G

Guest

I want to create a User Defined Function in SQL 2000, and then call that from
within Access97 VBA. How do I call the function from Access?
 
W

Wolfgang Kais

Hello Stu.

Stu W said:
I want to create a User Defined Function in SQL 2000, and then call
that from within Access97 VBA.
How do I call the function from Access?
Click to expand...

You can use a pass-through query or an ado command with a select
statement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling a UDF from a VB SQL statement 8
User Defined Function 6
How to get address of cell calling UDF? 2
Call a UDF from SQL 5
Call Report from SSRS 4
SQL Quotes help 5
Calendar control conversion issue 3
Example Of VBA SQL Statement 0

Top