Issue 177: Error when tryiny to execute SQL of a query in Microsoft Access that contains an expression using a custom VBA function within Access database
Status:  New
Owner: ----
Reported by jdadams...@gmail.com, May 23, 2011
What steps will reproduce the problem?
1.Create a custom function in Microsoft Access database. 
2.Create a query that contains an expression that uses custom function.
3.Execute pyodbc cursor of query. 

What is the expected output? What do you see instead?

Does not execute - error received.

What version of the product are you using? On what operating system?

Windows XP - Microsoft Access 2007, Python 2.6, pyodbc 2.1.8

Please provide any additional information below.

SQL passed to cursor.execute returns records within Microsoft Access database. 
May 26, 2013
#1 Gordon.D...@gmail.com
This is not a defect in pyodbc, it is just the way ODBC works with Access databases. User-defined custom functions written in VBA and saved as Access Module code are available to queries executed from within Access itself, but they are not available to queries executed via *any* ODBC connection to that Access database.