Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Exclamation 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 -

  2. #2
    Join Date
    Feb 2004
    Fine we know where it works, but we don't have ESP. So, could you cut n' paste the SQL and the code section in which you're trying to use it. It just might help us all out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts