Delete query failure in Access 2016 x64 redistributable

Question

Hi All,

We upgraded from access 2010 x64 to 2016 redistributable.

After installing 2016 redistributable, delete query is failing with HRESULT = -2147217900 ( 0x80040E14)

CDBErrorInfo GetAllErrorInfo gives below value for HRESULT code

pbstrDescription- [Itra L uoainerr],  pbstrSource -  McootAcs aaaeEgn

Table FRUITS

ID    FRUIT_NAME  FRUIT_DESCR

1      Apple            

2      Banana

3      Grape

DELETE FROM FRUITS WHERE FRUIT_NAME NOT IN ('Apple', 'Banana', 'Grape', NULL) AND FRUIT_NAME NOT LIKE '#*%'

Query is executed using

CCommand<CNoAccessor, CNoRowset> cmdDelete;

cmdDelete.Open(......);

This query is failing with access 2016 redistributable, but passing with access 2010

Connection string used -  Provider=Microsoft.ACE.OLEDB.12.0

Answer 1

I think you would be better of asking that question in ACCESS forum, this is SQL Server related forum

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 2

Raised question in ACCESS forum

Answer 3

People in that forum will help you.

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].