Access queries that call VBA functions from PHP via ODBC

[glenn-cns]

I am just wondering if anyone knows of any problems in running a query on an MS Access database from PHP via ODBC where the SQL contains references to VBA functions in the Access DB? (I have checked, of course, that the same query works fine from within Access)

I have many other places in this front-end project where I successfully have PHP query the database - usually only with minor changes (from how it works within Access) to get it to work over ODBC. However, this is the first query I've tried running that contains calls to VBA functions?

Anyone come across this before?

Glenn

[jheitz]

I haven't myself as I never use access, but I would guess (just a guess of course) that this will not work. Not only from PHP but whenever you are running the SQL outside Access.