WineHQ

Microsoft Access

Microsoft Office Access 2010 (32bit / x86)

Database application: Part of Microsoft Office 2010

Internal Version: 14.0.

A full featured database application for office use.

Application Details:

Version: 2010 (32bit)
License: Retail
URL: http://www.microsoft.com/acces...
Votes: Marked as obsolete
Latest Rating: Bronze
Latest Wine Version Tested: 1.5.5

Maintainers: About Maintainership

Free Download Access 2010

Test Results

Old test results
The test results for this version are very old, and as such they may not represent the current state of Wine. Please consider submitting a new test report.
Selected Test Results

What works

Most of basic tools. Constructor for tables, requests and forms.

What does not

Form and reports constructor can't save changes. Templates. Visual Basic. Most of macroses. UI elements with tables list.

Workarounds

What was not tested

Reports. I guess it works same as forms.

Hardware tested

Graphics:

  • GPU:
  • Driver:

Additional Comments

I used HOWTO from the Microsoft Office 2010 32-bit page on appdb.

selected in Test Results table below
Operating systemTest dateWine versionInstalls?Runs?Used
Workaround?
RatingSubmitter
CurrentUbuntu 12.04 "Precise" amd64 (+ variants like Kubuntu)Jun 08 20121.5.5Yes Yes Bronzean anonymous user 

Known Bugs

Bug # Description Status Resolution Other apps affected
29255 Microsoft Office 2003, 2007 & 2010 applications do not print OTF NEW View
37383 Office 2007/2010 - Submenus invisible on GNOME 3.14 UNCONFIRMED View
51098 Native Access fails to download files since Wine 6.6 UNCONFIRMED View

Show all bugs

Comments

The following comments are owned by whoever posted them. WineHQ is not responsible for what they say.

Success with MS Access 2010 with ODBC and form editing (Mint 20.1)
by Wayland Sothcott on Wednesday December 22nd 2021, 19:16
#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.
Linux Mint 20.1 MS Office Pro installed with PlayOnLinux in it's own virtual drive 6.18 32bit
by Wayland Sothcott on Tuesday December 21st 2021, 16:15
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.
Could not install with wine-3.6
by Stefan Haubenthal on Tuesday November 5th 2019, 8:57
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
Forms and their code
by Richard W on Thursday December 8th 2016, 11:37
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.
RE: Forms and their code
by Hanya Ngagunakeun on Friday March 6th 2020, 23:13
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?
query and relationship editor won't work
by Björn Bidar on Monday January 28th 2013, 19:08
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?
RE: query and relationship editor won't work
by Björn Bidar on Tuesday February 5th 2013, 6:10
I solved it by installing the windows dll of riched20
Forms and Reports
by Avinab Malla on Wednesday June 27th 2012, 10:13
Forms and reports work by overriding oleaut32 for MSACCESS.exe in winecfg
Back