Breaking ACE Out Of The Bubble

Published Feb 11 2020 12:04 PM 13.2K 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.  

28 Comments
%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%3CLINGO-SUB%20id%3D%22lingo-sub-2529670%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529670%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20is%20it%20that%20nearly%20a%20year%20since%20it%20was%20made%20available%20in%20all%20other%20versions%20this%20fix%20still%20hasn't%20been%20applied%20to%20the%20volume%20license%20version%20of%202019%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2530434%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F934117%22%20target%3D%22_blank%22%3E%40sjamm%3C%2FA%3E%26nbsp%3BThis%20is%20a%20significant%20feature%20update%2C%20and%20perpetual%2Fvolume%20license%20versions%20don't%20get%20significant%20feature%20updates%20(that%20is%20one%20of%20their%20features).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20will%20be%20fixed%20in%20the%202021%20volume%20license%20version.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShane%20Groff%3C%2FP%3E%0A%3CP%3EAccess%20Engineering%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2605037%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2605037%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%3B%3CBR%20%2F%3ECan%20you%20please%20check%20if%20there%20was%20something%20broken%20with%20ACE%20accessibility%20in%20the%20recent%20updates.%20My%20application%20tries%20to%20use%20Access%20DB%20engine%20and%20fails%20with%20error%20%22The%20operating%20system%20is%20not%20presently%20configured%22.%20Office%20365%20version%20is%20%2216.0.14228.20204%22.%20Repair%20does%20not%20help.%20I%20am%20pretty%20sure%20it%20was%20working%20few%20days%20or%20may%20be%20weeks%20ago.%20And%20it%20is%20not%20the%20issue%20of%20my%20application%20-%20here%20is%20the%20sample%20*.vbs%20code%20which%20was%20working%20fine%20previously%20and%20now%20fails%20with%20the%20same%20error%3A%3CBR%20%2F%3E%3CBR%20%2F%3EDim%20DBEngine%3CBR%20%2F%3ESet%20DBEngine%20%3D%20CreateObject(%22DAO.DBEngine.120%22)%3CBR%20%2F%3ECall%20MsgBox(%22Access%20DB%20Engine%20-%20OK%22)%3CBR%20%2F%3ESet%20DBEngine%20%3D%20Nothing%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2606595%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Konstantin%3C%2FP%3E%3CP%3EI'm%20using%20exactly%20the%20same%20version%20of%20Office%20365%20as%20you.%3C%2FP%3E%3CP%3EPerhaps%20I'm%20missing%20the%20point%20here%20but%20when%20I%20tested%20your%20vbs%20sample%2C%20I%20got%20this%20error%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22isladogs_0-1628017353379.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300260i870F4471E3915A96%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22isladogs_0-1628017353379.png%22%20alt%3D%22isladogs_0-1628017353379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOf%20course%20it%20works%20perfectly%20if%20I%20replace%20line%202%20with%3A%3C%2FP%3E%3CP%3ESet%20DBEngine%20%3D%20CreateObject(%22Access.Application%22)%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-2606712%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1007894%22%20target%3D%22_blank%22%3E%40isladogs%3C%2FA%3EHi%2C%20thank%20you%20for%20your%20reply%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20getting%20the%20same%20error%20as%20you%20in%20two%20cases%3A%3CBR%20%2F%3E1)%20when%20I%20run%20this%20vbs%20as%20x64%20on%20machine%20with%20office%20x32%20(basically%20to%20run%20these%204%20lines%20as%20is)%3CBR%20%2F%3E2)%20when%20I%20force%20to%20run%20this%20code%20as%20x32%20on%20machine%20with%20office%20x64.%20Here%20I%20use%20%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fa%2F15072320%2F282694%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ethis%20trick%3C%2FA%3E%20to%20force%20to%20run%20it%20as%20x32.%20Full%20vbs%20text%20below.%3C%2FP%3E%3CP%3EIn%20both%20cases%20that's%20the%20expected%20behaviour.%20x32%20office%20should%20expose%20x32%20dao%20which%20is%20not%20available%20from%20x64%20and%20vice%20versa.%3CBR%20%2F%3E%3CBR%20%2F%3EError%20I%20am%20talking%20about%20-%20%22The%20operating%20system%20is%20not%20presently%20configured%22%20-%20happens%20when%20I%20try%20to%20connect%20DAO%20using%20the%20same%20x32%2Fx64%20bitness%20as%20Office%20installation.%20All%20this%20thread%20is%20dedicated%20to%20the%20breakthru%20that%20DAO%2FOLEDB%20connectiity%20should%20become%20available.%20And%20now%20instead%20of%20that%20connectivity%20I%20am%20getting%20endless%20occurence%20of%20that%20error.%3CBR%20%2F%3E%3CBR%20%2F%3ECreateObject(%22Access.Application%22)%20-%20yes%2C%20it%20works%20fine%2C%20but%20that's%20not%20the%20subject%20of%20this%20discussion.%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20here%20is%20the%20full%20vbs%20I%20use%20to%20foce%20x32%20execution%20on%20x64%20machine%20(sorry%20some%20formatting%20may%20be%20broken)%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ECall%20Force32bit%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EDim%20DBEngine%3CBR%20%2F%3ESet%20DBEngine%20%3D%20CreateObject(%22DAO.DBEngine.120%22)%3CBR%20%2F%3ECall%20MsgBox(%22Access%20DB%20Engine%20-%20OK%22)%3CBR%20%2F%3ESet%20DBEngine%20%3D%20Nothing%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESub%20Force32bit()%3CBR%20%2F%3EDim%20sWinDir%2C%20sSys64%2C%20sSys32%2C%20oShell%3CBR%20%2F%3ESet%20oShell%20%3D%20CreateObject(%22WScript.Shell%22)%3CBR%20%2F%3EsWinDir%20%3D%20oShell.ExpandEnvironmentStrings(%22%25WinDir%25%22)%3CBR%20%2F%3EWith%20CreateObject(%22Scripting.FileSystemObject%22)%3CBR%20%2F%3EsSys64%20%3D%20.BuildPath(sWinDir%2C%20%22SysWOW64%22)%3CBR%20%2F%3EIf%20Not%20.FolderExists(sSys64)%20Then%20Exit%20Sub%3CBR%20%2F%3EsSys32%20%3D%20.BuildPath(sWinDir%2C%20%22System32%22)%3CBR%20%2F%3EIf%20sSys32%20%3D%20WScript.Path%20Then%3CBR%20%2F%3EoShell.CurrentDirectory%20%3D%20sSys64%3CBR%20%2F%3EoShell.Run%20%22wscript.exe%20%22%20%26amp%3B%20Chr(34)%20%26amp%3B%20_%3CBR%20%2F%3EWScript.ScriptFullName%20%26amp%3B%20Chr(34)%2C%201%2C%20False%3CBR%20%2F%3EWScript.Quit%3CBR%20%2F%3EEnd%20If%3CBR%20%2F%3EEnd%20With%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2607243%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2607243%22%20slang%3D%22en-US%22%3E%3CP%3EOK%20thanks.%20I'll%20study%20that%20code%20prperly%20later.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOut%20of%20interest%20are%20you%20aware%20that%2C%20contrary%20to%20widely%20expressed%20opinions%2C%20you%20can%20install%2032-bit%20and%2064-bit%20Office%20on%20the%20same%20machine%20in%20certain%20circumstances%20(without%20using%20a%20VM).%3C%2FP%3E%3CP%3EIf%20interested%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.utteraccess.com%2Ftopics%2F2061676%2Fposts%2F2784938%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.utteraccess.com%2Ftopics%2F2061676%2Fposts%2F2784938%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2613644%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ACE%20Out%20Of%20The%20Bubble%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613644%22%20slang%3D%22en-US%22%3E%3CP%3EInformation%20about%20the%20regression%20for%20using%20DAO%20from%20non-Office%20applications%20is%20posted%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Foffice%252Fc551294a-6f4e-4af5-a89f-e79e232b9898%26amp%3Bdata%3D04%257C01%257Cshaneg%2540microsoft.com%257C92f6a8e47e584dc7f24b08d95779256f%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637637000109493536%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3D5ZQ%252B7IwKYgK2yHiDrl6NsW5Ok%252FiOXtjvJoq%252F%252BQRJfW8%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Foffice%2Fc551294a-6f4e-4af5-a89f-e79e232b9898%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20fix%20will%20be%20available%20in%20Current%20Channel%20on%20Aug%2010%2C%20and%20is%20available%20now%20by%20updating%20to%20Version%202108%20which%20you%20can%20get%20by%20switching%20to%20Current%20Channel%20(Preview)%20(this%20isn't%20yet%20indicated%20in%20the%20link%20above%2C%20but%20it%20will%20be%20updated%20soon).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Feb 11 2020 12:05 PM
Updated by: