Q:

Using MS Access VBA Function using Query in VB6

I have defined a Function in MS Access database. I am using that function in Query. I saved that query as "Query1". This query runs successfully in MS Access. But, when I call the same query from VB (using ADO), it is giving me error:
Run-time error '-2147217900 (80040e14)':

Undefined function 'Concatenate' in expression.

Below is the code I use to access "Query1":
rs.Open "Select * From Query1", CN1, 2, 2
If Not rs.EOF Then
'Get Data
End If
rs.Close

A:

You cannot use user defined functions (UDFs) outside of Access. 

