Lets settle this once and for all!!! Can i call a user function in access2002 .ADP when linking to data in a SQL Server 7.

(I could do this fine in an Access database)

I have this code:
Set rec2 = New ADODB.Recordset
With rec2
Set .ActiveConnection = db
.Source = "SELECT Lead_Data.*, LEFT(LastName, 6) AS lastnamekey, addresskey(Address1) AS Addresskey FROM Lead_Data ORDER BY LEFT(Address1, 8)"
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
End With

Addresskey function is:

Function addresskey(textin As String)
Dim ctr As Integer
Dim current As String
Dim length As Integer
length = Len(textin)
ctr = 1
Do Until ctr > length
current = Mid(textin, ctr, 1)
Select Case current
Case "0" To "9"
Case Else
addresskey = Trim(addresskey) & Trim(current)
End Select
ctr = ctr + 1
End Function