![]() ![]() These scenarios are being addressed by the Access team. 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. ![]() Currently With ODBC, users still need to build DSNs to ACE data within an Office app. The team is working to expose ODBC and DAO interfaces very soon. 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. Custom applications will also be able to connect to Office data without installing the redist. This will now enable previously unsupported scenarios, including allowing PowerBI to connect to Office data. 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 (.16.0, or .12.0). Well, the Access team has good news for you. 2016, 2019, and O365 consumer versions of Access have not exposed its ACE engine outside of Office, including the ACE OLEDB provider. 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. Previously, users were required to install the Access Database Engine (ACE) Redistributable (or “redist”) to expose ACE outside of the Office bubble. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |