title: How to call Scalar-Valued function from Access
body: <p>I am working on a project in which my BE is Microsoft SQL Server 2008 R2 and my FE is Access 2010 in accdb format.
  I am trying to open a recordset that uses a Scalar-Valued function like so:</p>
  
  <pre><code>SELECT [ID], [FirstName], [LastName], [Comment]
  FROM [table general information]
  WHERE dbo.udf_StripHTML([Comments]) like '%Hello World%'
  ORDER BY [ID]
  </code></pre>
  
  <p>When I run this from within SQL Server everything works fine, but when I run this:</p>
  
  <pre><code>Dim rs As New ADODB.Recordset
  Dim con As ADODB.Connection
  
  Set con = Application.CurrentProject.Connection
  rs.Open strQuery, con, adOpenStatic
  </code></pre>
  
  <p>I get <code>Undefined function dbo.udf_StripHTML in expression</code></p>
  
  <p>I am assuming I'm using the wrong connection. If so - is there a built in property that I can get the connection from? And if that's not the case, what's the problem?</p>
  
  <p>Note: [table general information] is linked to a table in SQL Server</p>