Breaking ACE Out Of The Bubble

Published 02-11-2020 12:04 PM 8,590 Views
Microsoft

Previously, users were required to install the Access Database Engine (ACE) Redistributable (or “redist”) to expose ACE outside of the Office bubble. Upon transferring data between existing Microsoft Office files and those outside of Office, one needed to download a set of components to facilitate the process. 2016, 2019, and O365 consumer versions of Access have not exposed its ACE engine outside of Office, including the ACE OLEDB provider.

 

Well, the Access team has good news for you. If you have O365, or click-to-run versions of Access 2016/2019 Consumer installed, you will no longer need to install the ACE Redistributable to use the ACE OLEDB provider (Microsoft.ACE.OLEDB.16.0, or Microsoft.ACE.OLEDB.12.0). This will now enable previously unsupported scenarios, including allowing PowerBI to connect to Office data. Custom applications will also be able to connect to Office data without installing the redist.

 

If you have not installed Office, you can continue using the ACE redist, or you can install the Office 365 Access Runtime, which will include support for anything added after our 2016 MSI version. 

 

The team is working to expose ODBC and DAO interfaces very soon. Currently With ODBC, users still need to build DSNs to ACE data within an Office app. With DAO, users will still need a complete MSI Office installation to use SQL Server’s migration assistant, which transfers data from various sources into SQL Server. These scenarios are being addressed by the Access team.

 

Feedback

Please send us your thoughts and feedback on the first step of our ACE Redistributable process! The team is always looking for more ways to improve. You can leave comments here, or use the Send-A-Smile tool in Access to let us know what you think of this experience.  

21 Comments
Visitor

Hi Ebo,

 

I just wanted to know whether this initiative will allow creating 32-bit and 64-bit connectors side-by-side on the same machine. The use case is connecting 64-bit SSMA between 32-bit Access C2R and SQL Server 2019 (64-bit)?

 

Many thanks,

Graham R Seach

Access MVP (2001-2010)

Senior Member

Hello Ebo,

 

That's great news! Can you please clarify few questions:
1) How this change will be delivered to those who already have Office installed? Do they have to do Office update, or Windows update, or whatever else?
2) Office x64 COM objects such as Access.Application - they are accessible both for x86 and x64 consumer apps. Will this out-of-bubble ACE have the same feature? I mean if someone has Office x64 installed - will he be able to use Microsoft.ACE.OLEDB from x86 application?
3) As I remember this bubble thing was introduced in Office 2010. Can you please confirm that those who still use Office 2010 & 2013 - they still have to install ACE redistributable to be able to use Microsoft.ACE.OLEDB?

UPDATE and one more question -
4) when these changes will be available? I've just checked with my O365 x64 v 2001 build 12430.20184 which should be the latest for the current date - looks like it does not work yet.

 

Cheers,
Konstantin

Senior Member
Hi Ebo! this is good news! But please share more detailed information on the technical implementation of this "Bubble Breakout". Best regards, Philipp
Microsoft

@gseach Hi Graham.  No, this does not change the restrictions on having both 32-bit and 64-bit Office installed on a machine (it isn't supported).  If you are using 64-bit SSMA, then you need a 64-bit version of Ace, which means you should be using a 64-bit version of Office.

 

Shane

Microsoft

@k-semenenkov Hi Konstantin.  

1) This is part of the Office update, version 2001, which has build numbers starting with 16.0.12430.*

2) No, this works the same way that it works for MSI installs, including the Ace redist, if you have x64 Office installed, the COM components are only registered for 64-bit applications. While there are some ways to work around this if you are writing your own custom applications, the situation is exactly the same here as it was before the introduction of C2R.

3) Yes, we are not changing 2010 or 2013 C2R, so if you are using those, you will still need the Ace Redist.

4) That build should have the changes, can you explain what you tried, and what happened?

 

Shane

 

Senior Member

@Shane Groff
Thanks for update!
4) sorry, my mistake, I was so happy to read these news that I forgot that I am using DAO.DBEngine, not Microsoft.ACE.OLEDB.

Microsoft.ACE.OLEDB.16.0 works fine, but DAO.DBEngine.120 - not. As I understand it is still "in the bubble". I didn't check recent OLEDB provider features, but as I remember earlier it was not able to process some pure Access-specific data types such as attachments. Do you have plans to expose DAO.DBEngine.120 out of bubble?

Microsoft

Yes, we do plan to expose the DAO interfaces as well in a future release.

 

Shane

Microsoft

If you are using SSMA with the Access MSI runtime, and have O365 installed, you may find that SSMA stops working after O365 updates.

 

If you encounter this issue, the workaround is to reinstall the 2013 Access Runtime.  This problem will go away once O365 supports all of the COM interfaces for non-Office applications, at which point it will no longer be necessary to install an MSI build to use SSMA.

 

Shane

 
 

 

Occasional Visitor
Hi Shane, Any chance you could provide an approximation as to when the other COM interfaces will be included?
Occasional Visitor

"2016, 2019, and O365 consumer versions of Access have not exposed its ACE engine outside of Office..." If I am reading this correctly then ALL versions of Office 2016 and 2019, both C2R and MSI, also do not expose ACE outside of Office.  Is this correct?  If so are there plans to expose ACE for these MSI Office installations as well?

Microsoft

Only C2R installations have a bubble. For MSI installs, everything is exposed already.

If you have Office 2016 MSI, for example, you can already use the version of Ace installed with that version of Office in non-Office applications, there is no need to install the Access Database Engine Redistributable in that case.

Occasional Visitor

@Shane Groff Do you have any idea when ACEDAO support will be introduced for C2R Office installs? Thanks.

Microsoft

@GarethJHorton Yes, it is enabled in version 2009 and after, so it is available now in Current Channel builds.  For Semi-Annual Channel, it will be available in July 2021.

Occasional Visitor

Thanks for the quick response @Shane Groff

 

After the simple life of deploying ACE 2010, it looks a lot more complicated building an installer to deal with the matrix outlined in https://docs.microsoft.com/en-us/office/troubleshoot/access/cannot-use-odbc-or-oledb.

 

It's a shame there is no lightweight ACE 2013, the Runtime is pretty large and performing silent installation also appears to be somewhat challenging too.

 

Do you have a link for the canonical way to detect the channel/version of a C2R Office, so we can deploy/skip the A2013 Runtime appropriately?

 

Thanks

 

Gareth

Senior Member

Hi,

 

We got problem in our product with the "built-in" ACE in Office 365 version 2010, the 10th November release (Build 13328.20356).

It has been working with ACE2010 and ACE2016 in older Office-versions.

 

Any suggestions?

 

kimpan_0-1606206790765.png

 

Best regards,

 

Kim

Microsoft

@kimpan Kim,

 

Try uninstalling any previous Access Database Engine Redistributable / Runtime installations from the machine and then perform a repair of Office 365. 

 

If the issue persists, please provide reproduction steps that describe how you're interacting with ACE when you receive this message. Additionally, what happens if you click No to this prompt? Are any events recorded in the Event Viewer for Application Events?

 

Regards,

Dennis

Senior Member

Hi denniwil,

 

Thanks for your reply.

 

However it has nothing to do with older MSI- nor older C2R-versions of Office being preinstalled. It has been confirmed on clean Windows OS with Office C2R-versions only installed (Office 2016, Office 2019, Office 365 and Microsoft Apps 365). The versions 2010 release starting from 10th November 2020 and also the following and record-replacing version 2011.

 

What I notice in the code is that what worked in older Office-versions dating even back to Office 2010 (MSI) with ACE2010, Access 2013 Runtime and ACE2016, stopped working. When the AceCore warning appears, I see that a previously ODBC handle value that was closed using SQLDisconnect is being returned in the afterfollowing SQLDriverConnect which was called with different connection string (another MS Access db-file).

 

I have not been able to reproduce it in a demo solution to send it in to Microsoft Premier, but this occurs when MFC application A starts MFC Application B and both are accessing several MS Access files using ODBC functionality residing in a MFC DLL. 

 

Best regards,

 

Kim

 

Occasional Contributor

@kimpan, ODBC connectivity is not affected by this change yet. It is still "in the bubble". If I understand correctly, it is planned for early 2021 to also break the ODBC connectivity out of the bubble.

Senior Member

Hi Philipp,

 

From the 10th November 2020 releases of Office C2R (2016/(2019/365) technology based Office versions 2010 and 2011,  the ACE is "built-in" and "external/redist" ACE such as ACE2010, Access 2013 Runtime, ACE2016 should not be installed at all as it can cause malfunction.

 

This is the official statement we got from Microsoft Premier Support and if it's incorrect we would like to know.

 

If the "external/redist" ACE I mentioned above was installed prior to the Office update to version 2010 and 2011, then ACE must be uninstalled and Office needs to be repaired before ODBC works. This has been confirmed by our QA team.

 

Best regards,

 

Kim

 

 

 

 

Occasional Contributor

@kimpan , please read the post you are commenting under.


@Ebo_Quansah wrote:

The team is working to expose ODBC and DAO interfaces very soon. 

This is still not completed/released. Exposing ODBC is on the Access Roadmap for January 2021.

Best regards,

Philipp

Senior Member

@Philipp Stiefel 

 

According our contact at Microsoft Premier, it was already officially released from version 2010 released 10th November last year (2020).

 

You can try out yourself by downloading the officially released Click-to-run Office versions as I stated in my previous post using SqlDriverConnect (ODBC) or OleDispatchDriver (OLE).


Version 2012 has been been released since I wrote last time and the warning message still prevails. In one use case it also actually crashes in 

mso20win32client.dll.

 

What leads me to think it's a bug is:
  * Works with ACE2010, Access 2013 Runtime and ACE2016
  * If the Access DB file is opened first with SqlDriverConnect and then opened with OleDispatchDriver, it doesn't display any AceCore warning.  Switch the opening order then the message shows up. The warning also shows up in some combination of calls SqlDriverConnect and CDatabase::OpenEx.

 

Updated 2021-01-26:

It is confirmed by Microsoft as being a bug in Office with built-in ACE and planned to be fixed in May/June.
Support case [Case #:23694309]  -  ACE access using both ODBC and ACE OLEDB drivers stopped working after upgrading Office 2016

We are discussing internally if it is required with a hotfix prior to the plan.

 

Kim

%3CLINGO-SUB%20id%3D%22lingo-sub-1167712%22%20slang%3D%22en-US%22%3EBreaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167712%22%20slang%3D%22en-US%22%3E%3CP%3EPreviously%2C%20users%20were%20required%20to%20install%20the%20Access%20Database%20Engine%20(ACE)%20Redistributable%20(or%20%E2%80%9Credist%E2%80%9D)%20to%20expose%20ACE%20outside%20of%20the%20Office%20bubble.%20Upon%20transferring%20data%20between%20existing%20Microsoft%20Office%20files%20and%20those%20outside%20of%20Office%2C%20one%20needed%20to%20download%20a%20set%20of%20components%20to%20facilitate%20the%20process.%202016%2C%202019%2C%20and%20O365%20consumer%20versions%20of%20Access%20have%20not%20exposed%20its%20ACE%20engine%20outside%20of%20Office%2C%20including%20the%20ACE%20OLEDB%20provider.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWell%2C%20the%20Access%20team%20has%20good%20news%20for%20you.%20If%20you%20have%20O365%2C%20or%20click-to-run%20versions%20of%20Access%202016%2F2019%20Consumer%20installed%2C%20you%20will%20%3CSTRONG%3Eno%20longer%3C%2FSTRONG%3E%20need%20to%20install%20the%20ACE%20Redistributable%20to%20use%20the%20ACE%20OLEDB%20provider%20(Microsoft.ACE.OLEDB.16.0%2C%20or%20Microsoft.ACE.OLEDB.12.0).%20This%20will%20now%20enable%20previously%20unsupported%20scenarios%2C%20including%20allowing%20PowerBI%20to%20connect%20to%20Office%20data.%20Custom%20applications%20will%20also%20be%20able%20to%20connect%20to%20Office%20data%20without%20installing%20the%20redist.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20not%20installed%20Office%2C%20you%20can%20continue%20using%20the%20ACE%20redist%2C%20or%20you%20can%20install%20the%20Office%20365%20Access%20Runtime%2C%20which%20will%20include%20support%20for%20anything%20added%20after%20our%202016%20MSI%20version.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20team%20is%20working%20to%20expose%20ODBC%20and%20DAO%20interfaces%20very%20soon.%20Currently%20With%20ODBC%2C%20users%20still%20need%20to%20build%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Fen-us%252Fhelp%252F966849%252Fwhat-is-a-dsn-data-source-name%26amp%3Bdata%3D04%257C01%257CEbo.Quansah%2540microsoft.com%257C38a07db9b47b4c36461908d7ae58aa33%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637169568196863576%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DSTvKiWAt7JQSSa7st2Syb4fyWBmWY7BnJeizTFMXhLo%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDSNs%3C%2FA%3E%20to%20ACE%20data%20within%20an%20Office%20app.%20With%20DAO%2C%20users%20will%20still%20need%20a%20complete%20MSI%20Office%20installation%20to%20use%20SQL%20Server%E2%80%99s%20migration%20assistant%2C%20which%20transfers%20data%20from%20various%20sources%20into%20SQL%20Server.%20These%20scenarios%20are%20being%20addressed%20by%20the%20Access%20team.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFeedback%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EPlease%20send%20us%20your%20thoughts%20and%20feedback%20on%20the%20first%20step%20of%20our%20ACE%20Redistributable%20process!%20The%20team%20is%20always%20looking%20for%20more%20ways%20to%20improve.%20You%20can%20leave%20comments%20here%2C%20or%20use%20the%20Send-A-Smile%20tool%20in%20Access%20to%20let%20us%20know%20what%20you%20think%20of%20this%20experience.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1167712%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Access%20team%20shares%20exciting%20updates%20to%20the%20Access%20Database%20Engine%20(ACE)%20Redistributable.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1167712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Database%20Engine%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EACE%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%202016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%202019%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERedistributable%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1168106%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168106%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ebo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20wanted%20to%20know%20whether%20this%20initiative%20will%20allow%20creating%2032-bit%20and%2064-bit%20connectors%20side-by-side%20on%20the%20same%20machine.%20The%20use%20case%20is%20connecting%2064-bit%20SSMA%20between%2032-bit%20Access%20C2R%20and%20SQL%20Server%202019%20(64-bit)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3EGraham%20R%20Seach%3C%2FP%3E%3CP%3EAccess%20MVP%20(2001-2010)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1168784%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168784%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Ebo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20great%20news!%20Can%20you%20please%20clarify%20few%20questions%3A%3CBR%20%2F%3E1)%20How%20this%20change%20will%20be%20delivered%20to%20those%20who%20already%20have%20Office%20installed%3F%20Do%20they%20have%20to%20do%20Office%20update%2C%20or%20Windows%20update%2C%20or%20whatever%20else%3F%3CBR%20%2F%3E2)%20Office%20x64%20COM%20objects%20such%20as%20Access.Application%20-%20they%20are%20accessible%20both%20for%20x86%20and%20x64%20consumer%20apps.%20Will%20this%20out-of-bubble%20ACE%20have%20the%20same%20feature%3F%20I%20mean%20if%20someone%20has%20Office%20x64%20installed%20-%20will%20he%20be%20able%20to%20use%20Microsoft.ACE.OLEDB%20from%20x86%20application%3F%3CBR%20%2F%3E3)%20As%20I%20remember%20this%20bubble%20thing%20was%20introduced%20in%20Office%202010.%20Can%20you%20please%20confirm%20that%20those%20who%20still%20use%20Office%202010%20%26amp%3B%202013%20-%20they%20still%20have%20to%20install%20ACE%20redistributable%20to%20be%20able%20to%20use%20Microsoft.ACE.OLEDB%3F%3CBR%20%2F%3E%3CBR%20%2F%3EUPDATE%20and%20one%20more%20question%20-%3CBR%20%2F%3E4)%20when%20these%20changes%20will%20be%20available%3F%20I've%20just%20checked%20with%20my%20O365%20x64%20v%202001%20build%2012430.20184%20which%20should%20be%20the%20latest%20for%20the%20current%20date%20-%20looks%20like%20it%20does%20not%20work%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3CBR%20%2F%3EKonstantin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1171408%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171408%22%20slang%3D%22en-US%22%3EHi%20Ebo!%20this%20is%20good%20news!%20But%20please%20share%20more%20detailed%20information%20on%20the%20technical%20implementation%20of%20this%20%22Bubble%20Breakout%22.%20Best%20regards%2C%20Philipp%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172425%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F554012%22%20target%3D%22_blank%22%3E%40gseach%3C%2FA%3E%26nbsp%3BHi%20Graham.%26nbsp%3B%20No%2C%20this%20does%20not%20change%20the%20restrictions%20on%20having%20both%2032-bit%20and%2064-bit%20Office%20installed%20on%20a%20machine%20(it%20isn't%20supported).%26nbsp%3B%20If%20you%20are%20using%2064-bit%20SSMA%2C%20then%20you%20need%20a%2064-bit%20version%20of%20Ace%2C%20which%20means%20you%20should%20be%20using%20a%2064-bit%20version%20of%20Office.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172435%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F554506%22%20target%3D%22_blank%22%3E%40k-semenenkov%3C%2FA%3E%26nbsp%3BHi%20Konstantin.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20This%20is%20part%20of%20the%20Office%20update%2C%20version%202001%2C%20which%20has%20build%20numbers%20starting%20with%2016.0.12430.*%3C%2FP%3E%0A%3CP%3E2)%20No%2C%20this%20works%20the%20same%20way%20that%20it%20works%20for%20MSI%20installs%2C%20including%20the%20Ace%20redist%2C%20if%20you%20have%20x64%20Office%20installed%2C%20the%20COM%20components%20are%20only%20registered%20for%2064-bit%20applications.%20While%20there%20are%20some%20ways%20to%20work%20around%20this%20if%20you%20are%20writing%20your%20own%20custom%20applications%2C%20the%20situation%20is%20exactly%20the%20same%20here%20as%20it%20was%20before%20the%20introduction%20of%20C2R.%3C%2FP%3E%0A%3CP%3E3)%20Yes%2C%20we%20are%20not%20changing%202010%20or%202013%20C2R%2C%20so%20if%20you%20are%20using%20those%2C%20you%20will%20still%20need%20the%20Ace%20Redist.%3C%2FP%3E%0A%3CP%3E4)%20That%20build%20should%20have%20the%20changes%2C%20can%20you%20explain%20what%20you%20tried%2C%20and%20what%20happened%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShane%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1173177%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1173177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126077%22%20target%3D%22_blank%22%3E%40Shane%20Groff%3C%2FA%3E%3CBR%20%2F%3EThanks%20for%20update!%3CBR%20%2F%3E4)%20sorry%2C%20my%20mistake%2C%20I%20was%20so%20happy%20to%20read%20these%20news%20that%20I%20forgot%20that%20I%20am%20using%20DAO.DBEngine%2C%20not%20Microsoft.ACE.OLEDB.%3C%2FP%3E%3CP%3EMicrosoft.ACE.OLEDB.16.0%20works%20fine%2C%20but%20DAO.DBEngine.120%20-%20not.%20As%20I%20understand%20it%20is%20still%20%22in%20the%20bubble%22.%20I%20didn't%20check%20recent%20OLEDB%20provider%20features%2C%20but%20as%20I%20remember%20earlier%20it%20was%20not%20able%20to%20process%20some%20pure%20Access-specific%20data%20types%20such%20as%20attachments.%20Do%20you%20have%20plans%20to%20expose%20DAO.DBEngine.120%20out%20of%20bubble%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1173219%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1173219%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20we%20do%20plan%20to%20expose%20the%20DAO%20interfaces%20as%20well%20in%20a%20future%20release.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1180883%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1180883%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20using%20SSMA%20with%20the%20Access%20MSI%20runtime%2C%20and%20have%20O365%20installed%2C%20you%20may%20find%20that%20SSMA%20stops%20working%20after%20O365%20updates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20encounter%20this%20issue%2C%20the%20workaround%20is%20to%20reinstall%20the%202013%20Access%20Runtime.%26nbsp%3B%20This%20problem%20will%20go%20away%20once%20O365%20supports%20all%20of%20the%20COM%20interfaces%20for%20non-Office%20applications%2C%20at%20which%20point%20it%20will%20no%20longer%20be%20necessary%20to%20install%20an%20MSI%20build%20to%20use%20SSMA.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShane%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorShane%20Groff_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorShane%20Groff_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182423%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182423%22%20slang%3D%22en-US%22%3EHi%20Shane%2C%20Any%20chance%20you%20could%20provide%20an%20approximation%20as%20to%20when%20the%20other%20COM%20interfaces%20will%20be%20included%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1710860%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710860%22%20slang%3D%22en-US%22%3E%3CP%3E%22%3CSPAN%3E2016%2C%202019%2C%20and%20O365%20consumer%20versions%20of%20Access%20have%20not%20exposed%20its%20ACE%20engine%20outside%20of%20Office...%22%26nbsp%3B%3C%2FSPAN%3EIf%20I%20am%20reading%20this%20correctly%20then%20ALL%20versions%20of%20Office%202016%20and%202019%2C%20both%20C2R%20and%20MSI%2C%20also%20do%20not%20expose%20ACE%20outside%20of%20Office.%26nbsp%3B%20Is%20this%20correct%3F%26nbsp%3B%20If%20so%20are%20there%20plans%20to%20expose%20ACE%20for%20these%20MSI%20Office%20installations%20as%20well%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1710863%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710863%22%20slang%3D%22en-US%22%3E%3CP%3EOnly%20C2R%20installations%20have%20a%20bubble.%20For%20MSI%20installs%2C%20everything%20is%20exposed%20already.%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20Office%202016%20MSI%2C%20for%20example%2C%20you%20can%20already%20use%20the%20version%20of%20Ace%20installed%20with%20that%20version%20of%20Office%20in%20non-Office%20applications%2C%20there%20is%20no%20need%20to%20install%20the%20Access%20Database%20Engine%20Redistributable%20in%20that%20case.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1912898%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1912898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126077%22%20target%3D%22_blank%22%3E%40Shane%20Groff%3C%2FA%3E%26nbsp%3BDo%20you%20have%20any%20idea%20when%20ACEDAO%20support%20will%20be%20introduced%20for%20C2R%20Office%20installs%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1912913%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1912913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F875452%22%20target%3D%22_blank%22%3E%40GarethJHorton%3C%2FA%3E%26nbsp%3BYes%2C%20it%20is%20enabled%20in%20version%202009%20and%20after%2C%20so%20it%20is%20available%20now%20in%20Current%20Channel%20builds.%26nbsp%3B%20For%20Semi-Annual%20Channel%2C%20it%20will%20be%20available%20in%20July%202021.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1913030%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1913030%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20quick%20response%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126077%22%20target%3D%22_blank%22%3E%40Shane%20Groff%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20the%20simple%20life%20of%20deploying%20ACE%202010%2C%20it%20looks%20a%20lot%20more%20complicated%20building%20an%20installer%20to%20deal%20with%20the%20matrix%20outlined%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Faccess%2Fcannot-use-odbc-or-oledb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Faccess%2Fcannot-use-odbc-or-oledb%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20shame%20there%20is%20no%20lightweight%20ACE%202013%2C%20the%20Runtime%20is%20pretty%20large%20and%20performing%20silent%20installation%20also%20appears%20to%20be%20somewhat%20challenging%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20link%20for%20the%20canonical%20way%20to%20detect%20the%20channel%2Fversion%20of%20a%20C2R%20Office%2C%20so%20we%20can%20deploy%2Fskip%20the%20A2013%20Runtime%20appropriately%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGareth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1926119%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1926119%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20got%20problem%20in%20our%20product%20with%20the%20%22built-in%22%20ACE%20in%20Office%20365%20version%202010%2C%20the%2010th%20November%20release%20(Build%2013328.20356).%3C%2FP%3E%3CP%3EIt%20has%20been%20working%20with%20ACE2010%20and%20ACE2016%20in%20older%20Office-versions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kimpan_0-1606206790765.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235737i2317D98362082D3A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22kimpan_0-1606206790765.png%22%20alt%3D%22kimpan_0-1606206790765.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1953861%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1953861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879669%22%20target%3D%22_blank%22%3E%40kimpan%3C%2FA%3E%26nbsp%3BKim%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20uninstalling%20any%20previous%20Access%20Database%20Engine%20Redistributable%20%2F%20Runtime%20installations%20from%20the%20machine%20and%20then%20perform%20a%20repair%20of%20Office%20365.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20issue%20persists%2C%20please%20provide%20reproduction%20steps%20that%20describe%20how%20you're%20interacting%20with%20ACE%20when%20you%20receive%20this%20message.%20Additionally%2C%20what%20happens%20if%20you%20click%20No%20to%20this%20prompt%3F%20Are%20any%20events%20recorded%20in%20the%20Event%20Viewer%20for%20Application%20Events%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EDennis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984499%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984499%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20denniwil%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20it%20has%20nothing%20to%20do%20with%20older%20MSI-%20nor%20older%20C2R-versions%20of%20Office%20being%20preinstalled.%20It%20has%20been%20confirmed%20on%20clean%20Windows%20OS%20with%20Office%20C2R-versions%20only%20installed%20(Office%202016%2C%20Office%202019%2C%20Office%20365%20and%20Microsoft%20Apps%20365).%20The%20versions%202010%20release%20starting%20from%2010th%20November%202020%20and%20also%20the%20following%20and%20record-replacing%20version%202011.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20notice%20in%20the%20code%20is%20that%20what%20worked%20in%20older%20Office-versions%20dating%20even%20back%20to%20Office%202010%20(MSI)%20with%20ACE2010%2C%20Access%202013%20Runtime%20and%20ACE2016%2C%20stopped%20working.%20When%20the%20AceCore%20warning%20appears%2C%20I%20see%20that%20a%20previously%20ODBC%20handle%20value%20that%20was%20closed%20using%20SQLDisconnect%20is%20being%20returned%20in%20the%20afterfollowing%20SQLDriverConnect%20which%20was%20called%20with%20different%20connection%20string%20(another%20MS%20Access%20db-file).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20not%20been%20able%20to%20reproduce%20it%20in%20a%20demo%20solution%20to%20send%20it%20in%20to%20Microsoft%20Premier%2C%20but%20this%20occurs%20when%20MFC%20application%20A%20starts%20MFC%20Application%20B%20and%20both%20are%20accessing%20several%20MS%20Access%20files%20using%20ODBC%20functionality%20residing%20in%20a%20MFC%20DLL.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKim%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984831%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879669%22%20target%3D%22_blank%22%3E%40kimpan%3C%2FA%3E%2C%20ODBC%20connectivity%20is%20not%20affected%20by%20this%20change%20yet.%20It%20is%20still%20%22in%20the%20bubble%22.%20If%20I%20understand%20correctly%2C%20it%20is%20planned%20for%20early%202021%20to%20also%20break%20the%20ODBC%20connectivity%20out%20of%20the%20bubble.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1992656%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992656%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Philipp%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20the%2010th%20November%202020%20releases%20of%20Office%20C2R%20(2016%2F(2019%2F365)%20technology%20based%20Office%20versions%20%3CSTRONG%3E2010%3C%2FSTRONG%3E%20and%20%3CSTRONG%3E2011%3C%2FSTRONG%3E%2C%26nbsp%3B%20the%20ACE%20is%20%22built-in%22%20and%20%22external%2Fredist%22%20ACE%20such%20as%20ACE2010%2C%20Access%202013%20Runtime%2C%20ACE2016%26nbsp%3B%3CSTRONG%3Eshould%20not%26nbsp%3B%3C%2FSTRONG%3Ebe%20installed%20at%20all%20as%20it%20can%20cause%20malfunction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20official%20statement%20we%20got%20from%20Microsoft%20Premier%20Support%20and%20if%20it's%20incorrect%20we%20would%20like%20to%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20%22external%2Fredist%22%20ACE%20I%20mentioned%20above%20was%20installed%20prior%20to%20the%20Office%20update%20to%20version%202010%20and%202011%2C%20then%20ACE%20must%20be%20uninstalled%20and%20Office%20needs%20to%20be%20repaired%20before%20ODBC%20works.%20This%20has%20been%20confirmed%20by%20our%20QA%20team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKim%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1995094%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1995094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879669%22%20target%3D%22_blank%22%3E%40kimpan%3C%2FA%3E%26nbsp%3B%2C%20please%20read%20the%20post%20you%20are%20commenting%20under.%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384551%22%20target%3D%22_blank%22%3E%40Ebo_Quansah%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EThe%20team%20is%20working%20to%20expose%20ODBC%20and%20DAO%20interfaces%20very%20soon.%26nbsp%3B%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThis%20is%20still%20not%20completed%2Freleased.%26nbsp%3BExposing%20ODBC%20is%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Froadmap%3Ffilters%3DAccess%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAccess%20Roadmap%3C%2FA%3E%20for%20January%202021.%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EPhilipp%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2049299%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2049299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126102%22%20target%3D%22_blank%22%3E%40Philipp%20Stiefel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20our%20contact%20at%20Microsoft%20Premier%2C%20it%20was%20already%20officially%20released%20from%20version%202010%20released%2010th%20November%20last%20year%20(2020).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20out%20yourself%20by%20downloading%20the%20officially%20released%20Click-to-run%20Office%20versions%20as%20I%20stated%20in%20my%20previous%20post%20using%20SqlDriverConnect%20(ODBC)%20or%20OleDispatchDriver%20(OLE).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EVersion%202012%20has%20been%20been%20released%20since%20I%20wrote%20last%20time%20and%20the%20warning%20message%20still%20prevails.%20In%20one%20use%20case%20it%20also%20actually%20crashes%20in%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3Emso20win32client.dll.%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20leads%20me%20to%20think%20it's%20a%20bug%20is%3A%3CBR%20%2F%3E%26nbsp%3B%20*%20Works%20with%20ACE2010%2C%20Access%202013%20Runtime%20and%20ACE2016%3CBR%20%2F%3E%26nbsp%3B%20*%20If%20the%20Access%20DB%20file%20is%20opened%20first%20with%20SqlDriverConnect%20and%20then%20opened%20with%20OleDispatchDriver%2C%20it%20doesn't%20display%20any%20AceCore%20warning.%26nbsp%3B%20Switch%20the%20opening%20order%20then%20the%20message%20shows%20up.%20The%20warning%20also%20shows%20up%20in%20some%20combination%20of%20calls%20SqlDriverConnect%20and%20CDatabase%3A%3AOpenEx.%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdated%202021-01-26%3A%3C%2FP%3E%3CP%3EIt%20is%20confirmed%20by%20Microsoft%20as%20being%20a%20bug%20in%20Office%20with%20built-in%20ACE%20and%20planned%20to%20be%20fixed%20in%20May%2FJune.%3CBR%20%2F%3ESupport%20case%26nbsp%3B%5BCase%20%23%3A23694309%5D%26nbsp%3B%20-%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fserviceshub.microsoft.com%2Fsupport%2Fcase%2F121011425003844%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EACE%20access%20using%20both%20ODBC%20and%20ACE%20OLEDB%20drivers%20stopped%20working%20after%20upgrading%20Office%202016%3C%2FA%3E%3C%2FP%3E%3CP%3EWe%20are%20discussing%20internally%20if%20it%20is%20required%20with%20a%20hotfix%20prior%20to%20the%20plan.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKim%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Feb 11 2020 12:05 PM
Updated by: