Results 1 to 4 of 4
  1. #1
    Rxp is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    15

    query stop working after migration of data to sql server from access

    I am new to access and I don't know what is going on..may be you guys can help!

    SELECT qry000OrderDetailList.*, qryLstOrderProducts.ProductID,qryLstOrderProducts. ProductTypeID,


    qryLstOrderProducts.LanguageID,qryLstProducts.Prod uctName,
    qryLstOrderProducts.ProdctDescription,qryLstOrderP roducts.UnitsInStock,
    qryLstOrderProducts.UnitsOnOrder,qryLstOrderProduc ts.WhseStock,qryLstOrderProducts.QtyOut,
    qryLstOrderProducts.QtyRet,qryLstOrderProducts.Pro ductType,qryLstOrderProducts.Language,
    qryLstOrderProducts.IncludePR,qryLstOrderProducts. IncludePT,qryLstOrderProducts.IncludeLG

    FROM qry000OrderDetailList INNER JOIN qryLstOrderProducts ON qry000OrderDetailList.OrderID=qryLstOrderProducts. OrderID;

  2. #2
    TheShabz is offline Court Jester
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    1,368
    What's the error?

    (I'm assuming those spaces in your SQL are from copy/paste from text editor and not actually in your query)

  3. #3
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    Thanks for the reply. When I run it ,Access just hangs up and I have to restart it again. Yes, you are right about the spaces. Actually, there are few other queries too, including the above in the same database which stopped working after migrating access back end to sql server.

  4. #4
    TheShabz is offline Court Jester
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    1,368
    Do a SELECT * FROM each table involved. See if it works. If not, then its your connection to the new DB.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Data Migration to New Database Design
    By neo651 in forum Import/Export Data
    Replies: 2
    Last Post: 04-19-2012, 06:36 PM
  2. Stop Access Changing My Data
    By R3mix3r in forum Access
    Replies: 5
    Last Post: 09-11-2011, 10:33 PM
  3. cascading combo boxes stop working in DAP system
    By James Brazill in forum Forms
    Replies: 5
    Last Post: 06-28-2011, 03:51 AM
  4. Replies: 9
    Last Post: 03-29-2011, 07:08 PM
  5. Replies: 0
    Last Post: 12-20-2010, 12:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums