Wednesday, 17 February 2016

System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

I am getting this error 'System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005)' while running the below MS Access select query:
Select Title, Address, Size, LastModifiedDate From MyTable


The problem is due to the Reserved keyword Size. The problem solved after changed the query by enclosing the Reserved keyword with square brackets ([])
Select Title, Address, [Size], LastModifiedDate From MyTable


No comments:

Post a Comment