If you want to install 64-bit Microsoft Access DatabaseĮngine 2016, you will first need to remove the 32-bit installation of You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office products It works well enough to be useful but not well enough to migrate to Linux an existing MS Access database that a business might be using under Windows.We have a workstation running Windows 10 (1709.16299.2166) with Office 365 on which I was asked to install Microsoft Access Database Engine 2016 for a consultant.Īfter downloading the installer for the 64-bit version and trying to install it, I was greeted with the following error message: Everything was reliable unless it failed. Things ether refused to work or crashed out of Access every time. I did not get any random crashes or weirdness. I think it's from MDAC28 libruary which refuses to install. The normal ODBC32 thing in Control Panel / Administration is nowhere to be found. The 'external data' button reports that it can't find any ODBC DSN. However it would be more useful if I could ODBC into a MySQL database like I normally do with Access. I tried a very simple existing form and it works fine.Īs a tool for mooshing data I think it's usable and probably easier better than anything Linux has to offer. The WINE Access is able to open this cleaned up database and show tables and run queries. So in Windows I imported all the objects except code into a fresh database. I tried importing from an existing database but Access crashed. I let Access create a new database and tables in this seem fine. I decided to have another go a bit less ambitious. The majority of MS Office 2010 works but Access has always been a problem. I've been wanting this to work for a while. OLE does not seem to work so no bar graphs or other fancy stuff This is a pretty big download, maybe the whole of Windows 7 haha. The problem with editing forms and reports can be solved with the following command from the same shell MySQL will be one of the drivers available. That will mean in Access press the "External Data" tab then press "ODBC database" where you can create a DSN in the normal way. The easiest way to get that is with Winetricks installed on your Linux PC.įrom the same Miscellaneous tab instead press the button "Open a Shell". However it still needs to be enabled in Access so you need MDAC28. This should bring up the normal installation window for this driver. I use this one downloaded from Oracle MySQL community edition mysql-connector-odbc-3.51.30-win32.msi EXE in this virtual drive" then browse for the. The ODBC for MYSQL (MariaDB) can be installed from PlayOnLinux by going into configuration then the virtual drive for Access then Miscellanious "run a windows. The other thing missing is ODBC so you can't connect to a server database. Forms sort of run but buttons don't work and you can't add new fields. You can create, edit and run tables and queries. If you limit your scope to what does work then you can import Access tables, queries, forms and reports. The first thing to notice when loading an existing database if it does not crash is that macros and VBA calls fail. Seems OK to upgrade to Wine 6.18 after installation. I think Outlook is OK and I expect the other ones too. PlayOnLinux has a script for this installation which works fine. MS Access 2010 Pro (with Access) 32 bit installation files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |