Unanswered: SQL Query not working in code, but works in Query
I have an access database linking to a test SQL server dbase. The code in the form for a simple SQL select stement is getting caught up in debugging, but when I copy it and run it in the Access query or the SQL server query - it works fine. Also when I the code in our prod server it works perfectly fine, I also varified that all the tables are populated correctly, that the SQL that I use for other version of the database work fine as well.
If anyone has any ideas of why this is happening - just let me know -