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

    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
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by kmonihan
    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 -
    Let's see the code that's blowing ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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