Microsoft Access

#MS Office 2010 under Linux WINE

#Using
PlayOnLinux to manage my WINE instances. MS Access 2010 Pro (with Access) 32 bit installation files. WineTricks

#Installation
PlayOnLinux has a script for this installation which works fine.
Word and Excel seem perfect. I think Outlook is OK and I expect the other ones too. Seems OK to upgrade to Wine 6.18 after installation.
The problem is MS Access. There are features missing

#MS Access missing features
The first thing to notice when loading an existing database if it does not crash is that macros and VBA calls fail. If you limit your scope to what does work then you can import Access tables, queries, forms and reports. You can create, edit and run tables and queries. Forms sort of run but buttons don't work and you can't add new fields.

The other thing missing is ODBC so you can't connect to a server database.

#Installing the missing components
#ODBC
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 .EXE in this virtual drive" then browse for the .MSI file.

I use this one downloaded from Oracle MySQL community edition; mysql-connector-odbc-3.51.30-win32.msi
This should bring up the normal installation window for this driver.

However it still needs to be enabled in Access so you need MDAC28. The easiest way to get that is with Winetricks installed on your Linux PC.

From the same Miscellaneous tab instead press the button "Open a Shell". In the shell enter the following;

winetricks mdac28

That will mean in Access press the "External Data" tab then press "ODBC database" where you can create a DSN in the normal way. MySQL will be one of the drivers available.

#Editing forms and making macros work

The problem with editing forms and reports can be solved with the following command from the same shell;

winetricks oleaut32

This is a pretty big download, maybe the whole of Windows 7 haha.

#What's still missing
OLE does not seem to work so no bar graphs or other fancy stuff



Have fun.

I've been wanting this to work for a while. The majority of MS Office 2010 works but Access has always been a problem.
I decided to have another go a bit less ambitious. I let Access create a new database and tables in this seem fine. I tried importing from an existing database but Access crashed.
So in Windows I imported all the objects except code into a fresh database. The WINE Access is able to open this cleaned up database and show tables and run queries. No VBA modules.

I tried a very simple existing form and it works fine.

As a tool for mooshing data I think it's usable and probably easier better than anything Linux has to offer. However it would be more useful if I could ODBC into a MySQL database like I normally do with Access. The 'external data' button reports that it can't find any ODBC DSN. The normal ODBC32 thing in Control Panel / Administration is nowhere to be found. I think it's from MDAC28 libruary which refuses to install. I did not get any random crashes or weirdness. Things ether refused to work or crashed out of Access every time. Everything was reliable unless it failed. To me this is a good thing.

Conclusion
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.

00e5:err:winediag:load_gssapi_krb5 Failed to load libgssapi_krb5, Kerberos SSP support will not be available.
00eb:err:msi:create_temp_binary failed to load dll L"C:\\users\\shaube\\Temp\\msib8a3.tmp" (193)
0131:err:msi:ACTION_CallDllFunction failed to load dll L"C:\\users\\shaube\\Temp\\msib8a3.tmp" (193)
00eb:err:msi:create_temp_binary failed to load dll L"C:\\users\\shaube\\Temp\\msib8a5.tmp" (193)
0132:err:msi:ACTION_CallDllFunction failed to load dll L"C:\\users\\shaube\\Temp\\msib8a5.tmp" (193)
013b:err:eventlog:ReportEventW L"0x80070002"
013b:err:eventlog:ReportEventW L"14.0.370.400"
00eb:err:msi:ITERATE_Actions Execution halted, action L"StartServices" returned 1627
00eb:err:rpc:RpcAssoc_BindConnection rejected bind for reason 0
00e5:err:rpc:RpcAssoc_BindConnection rejected bind for reason 0

wine-1.9.22 (Debian 1.9.22-1)

I installed MS Access 2010 32 bit to a fresh WINEPREFIX. This is a standalone version of Access ie. No other Office products are included. I did a typical install.

1.
If I open a pre-existing database, it appears to work until any event triggers some VB. When it does, I receive "The expression On Click you entered as the event property setting has produced the following error:
- The expression may not result in the name of a macro, a user-defined function... etc. (It does)
- There may have been an error evaluating the function, macro, or event. (There was, obviously. I just don't know how to fix it)

2.
If I create a new form and attempt to add a widget, I receive a "Microsoft Access can't create any more controls on this form or report" error.

I tried adding oleaut32 as an override as suggested but when I opened a database I received an "oleaut32 is too old" error message followed by a crash.


Thank you in advance for any ideas you may have.

I have the same problem, I'm using Wine 5.3 (the latest as of now). I tried to use switchboard manager but there just empty list and I can't click new or close because whenever i click that, it shows "The expression On Click...." Does anyone have the solution?

After I installed acces 20, I can't select any table or query in the relationship editor or in the query any editor. Anyone has an Idea?

I solved it by installing the windows dll of riched20

Forms and reports work by overriding oleaut32 for MSACCESS.exe in winecfg