MSAccess - Date(), Str() function causing Runtime Error 13 in ACCDE
Posted on 2012-03-22
In development, MS Access 2010, queries using the Date() function and Str() function work just fine.
When I compile to an ACCDE however and run under Access Runtime 2010, execution of these queries generates a runtime error 13, type mismatch.
All references are set correctly. If they were not, the functions would not work in development.