none
Internal OLE Automation error - MS Access 2007

    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

Answers

  • 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