%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
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.  

9 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

Regular Visitor
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?