Error when tryiny to execute SQL of a query in Microsoft Access that contains an expression using a custom VBA function within Access database

djhenderson / pyodbc

Automatically exported from code.google.com/p/pyodbc

MIT No Attribution

0 stars 0 forks source link

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.

Original issue reported on code.google.com by jdadams...@gmail.com on 23 May 2011 at 4:46

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.

djhenderson / pyodbc

Error when tryiny to execute SQL of a query in Microsoft Access that contains an expression using a custom VBA function within Access database #177