Ms access current recordset does not support updating

The only limitation I am aware of is the same you were encountering with JET which is that you can't have multiple users connecting to and modifying the Excel file.Microsoft Access Database Engine 2016 Redistributable https:// To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior.If you have already updated the package from JET to ACE, then this will not show the connection manager and is not affected by this security update.

ms access current recordset does not support updating-4ms access current recordset does not support updating-84ms access current recordset does not support updating-36

Ms access current recordset does not support updating

id=54920 When looking into this issue, the largest thing to note is: The JET provider has been deprecated as of 2002. In other words, MDAC 2.6, 2.7, 2.8, and all future MDAC/WDAC releases do not contain Microsoft Jet, the Microsoft Jet OLE DB Provider, the ODBC Desktop Database Drivers, or Jet Data Access Objects (DAO).

The Microsoft Jet Database Engine 4.0 components entered a state of functional deprecation and sustained engineering and have not received feature level enhancements since becoming a part of Microsoft Windows in Windows 2000 So, in short the JET provider has been working for a good 15 years after deprecation, but this most recent update caused a change which requires an update to how you are connecting to the Excel file.

To do so, download the desired Access Database or Access Databae Engine_x64to your PC, open an administrative command prompt, and provide the installation path and switch /quiet. Please note that this approach is not recommended and haven't worked in few instances, so would request you to move to 2 different server approach if possible.

This patch seems to update Excel Jet connector from V4.00.9801.0 to v4.00.9801.1.

I've successfully created and OLE DB "IBMDASQL" connection, and am able to pull data some data, but i'm running into an issue when i try to pull data from a very large table This runs fine, and returns a count of 170 million: I'm a Microsoft guy, but my AS/400 guy says that there is an index on the 'processed' column and that locally, that query run instantaneously. I found a table with only 68 records in it, and was able to run this query in about a second: I have had to fight this battle many times. 1) Stage your data from the AS400 into SQL server where you can optimize your indexes 2) Ask the AS400 folks to create logical views which speed up data retrieval, your AS400 programmer is correct, index will help but I forget the term they use to define a "view" similar to a sql server view, I beleive its something like "physical" v/s "logical". Thirdly, 170 million is a lot of records, even for a relational database like SQL server, have you considered running an SSIS package nightly that stages your data into your own SQL table to see if it improves performance?