What is causing my OLEDbException, IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

by

I apparently was mistaken when I said the query did not contain any reserved words.

The query I was using was selecting from another query in the Access Database. That other query had a reserved keyword that was causing the problem.

BTW:

The Access database engine runs in different modes, depending on whether it is called from Access, data access objects, the Microsoft OLE Provider for the Access database engine, or the Microsoft Access ODBC driver. It can be run in either ANSI mode or non-ANSI (traditional) mode.

Because using these two modes results in two slightly different sets of reserved words, a query that uses a reserved word might work in one mode and fail in another mode

Access 2007 reserved words and symbols

Keith

More Related Contents:

  1. Why not use exceptions as regular flow of control?
  2. Dealing with “java.lang.OutOfMemoryError: PermGen space” error
  3. When to throw an exception?
  4. Better exception for non-exhaustive patterns in case
  5. Why should I not wrap every block in “try”-“catch”?
  6. Is it really that bad to catch a general exception?
  7. Could not load file or assembly System.Net.Http.Primitives. Located assembly’s manifest definition does not match the assembly reference
  8. Design by contract using assertions or exceptions? [closed]
  9. Cause of Servlet’s ‘Response Already Committed’ [duplicate]
  10. try-catch exceptions in Swift [duplicate]
  11. Why not catch general Exceptions
  12. When is it right for a constructor to throw an exception?
  13. simple IPython example raises exception on sys.exit()
  14. Why is exception handling bad? [closed]
  15. How do exceptions in Haskell work?
  16. How do I not log a particular type of Exception in Logback?
  17. Why are Exceptions said to be so bad for Input Validation?
  18. Can I get detailed exception stacktrace in PowerShell?
  19. Autonumber value of last inserted row – MS Access / VBA
  20. Is it possible to pass parameters programmatically in a Microsoft Access update query?
  21. How to get random record from MS Access database
  22. How to simulate UNPIVOT in Access?
  23. .NET – What’s the best way to implement a “catch all exceptions handler”
  24. Rounding in MS Access
  25. Achieving ROW_NUMBER / PARTITION BY in MS Access
  26. What causing this “Invalid length for a Base-64 char array”
  27. How is the C++ exception handling runtime implemented?
  28. Is there an equivalent to Thread.Sleep() in VBA
  29. Is there anything like .NET’s NotImplementedException in Java?
  30. Intermittent asp.net mvc exception: “A public action method ABC could not be found on controller XYZ.”

Leave a Comment