Internal OLE Automation error - MS Access 2007 RRS feed

  • Question

  • I am using MS Access -2007 on windows server -2003.  on my one of the query I get "Internal OLE automation error" after it runs.
    It shows data for a moment then data gets deleted from query when I hit OK button on Internal OLE automation error.

    SELECT Qry_SNew.*, IIf([Qry_SNew].[Score1]>3.5,99.9663, IIf([Qry_SNew].[Score1] < -3.5 , 0.03369,[Tbl_percent].[Percentile])) AS Percentile1
    FROM Qry_SNew LEFT JOIN Tbl_percent ON Qry_SNew.Score1 = [Tbl_percent].score;
    Friday, January 15, 2010 4:23 PM


  • I found solution for this question, it was a error in sub query which link to master query in join.

    • Marked as answer by Jay033 Friday, January 15, 2010 6:22 PM
    Friday, January 15, 2010 6:22 PM

All replies