3

Configure MS Access with Wine in Ubuntu 10.04

Since I started using Ubuntu two years ago, I almost give up using any Windows applications and any required features or functionalities can be achieved in Ubuntu and probably even better than what I want.

Recently, I was being forced to use Microsoft Access for my Database assignment. From someone that has a few years of working experience point of view, I really feel such enforcement is totally unacceptable because Microsoft Access is not a commercial database and it’s not cross-platform compatibility as well. This is quite annoying and unfair for someone that using Linux platform such as me. Minority users not equal to non-existence. Besides that, I feel students should be exposed to the real-word business and cross-platform database tools such as MySQL or PostgreSQL will be a better choice. Well, from a student point of view, MS Access is the easiest tool for students to get the picture of how the basic database works.

So, I spent my day and night with drinking “wine” last week :P. There are several Microsoft products required to be used in other assignments as well but I was able to find other softwares to used them in Ubuntu. Unfortunately, the required database format for submission must be .mdb and I can’t find any other softwares to create .mdb file. That makes me even frustrated with Microsoft and want to prove to myself that nothing is impossible in Linux. I don’t believe Linux can be defeated by just one Microsoft Access and also all these time, I was able to run other applications in Ubuntu to replace Microsoft products.

Wine 1.2

At the current moment, the latest version of Wine in Ubuntu 10.04 is 1.2 but if you had upgraded your Ubuntu version to 10.10, you will get version 1.3. At the beginning, I installed the version 1.2 and experienced a lot of problems. Here are some of the errors and possible fixes to resolve the errors:

  • Try to open MSACCESS.exe but ends up with the error related to msxml3.dll
    yee@chimney:~/Desktop$ wine MSACCESS.exe
    err:process:__wine_kernel_init boot event wait timed out
    err:ole:COMPOBJ_DllList_Add couldn't load in-process dll L"msxml3.dll"
    err:ole:create_server class {2933bf90-7b36-11d2-b20e-00c04f983e60} not registered
    fixme:ole:CoGetClassObject CLSCTX_REMOTE_SERVER not supported
    err:ole:CoGetClassObject no class object {2933bf90-7b36-11d2-b20e-00c04f983e60} could be created for context 0x17
    

    Solution: Install msxm3.dll with winetricks or download from sites.

  • msvcr80.dll installed in System32, run the installer wine MSACCESS.EXE: Runtime Error!

    Solution: Remove MSVCR80.dll installed in System32.

  • Program: C:Program FilesMicrosoft OfficeOffice12MSACCESS.EXE
    
    R6034
    An application has made an attempt to load the C runtime library incorrectly.
    Please contact the application's support team for more information.
    

    Solution: reinstall the package: vcrun2005 with ./winetricks


Wine 1.3

Things are much better and lesser errors in wine 1.3. If you are running Ubuntu 10.04. you will need to download wine1.3 from here: https://launchpad.net/~ubuntu-wine/+archive/ppa/+build/2117464. I was able to get Microsoft Access runs in Ubuntu with wine 1.3 but you might encounter a few errors which can be easily fixed:-

  • If there is a popup of DDE Error when you are trying to open the application, it means that you had chosen the wrong Windows version. For example, the correct Windows version that I should choose is Windows XP but if I choose to run in Windows Vista, there will be a popup window with the message “DDE Error”.
  • If you see the following error message, it means that you had a missing a library or the application can’t find the reference to the fdao360.dll file:
    Your Microsoft Office Access database or project contains a missing or broken reference to the file 'dao360.dll' version 5.0.

    Solution:The correct folder or location for the file is /home//.wine/dosdevices/c:/Program Files/Common Files/Microsoft Shared/dao/dao360.dll. What you need to do is click Ctrl+G in MS Access and you need to fix the broken reference. The following site provides a very detailed on how to fix the problem: http://allenbrowne.com/ser-38.html.


What is Not Working for MS Access with Wine?

Reports not working for me. I got a blank windows every time I clicked the Report Wizard. I think most of the wizards are not working.


Other Useful References

p.s: I just realized there was such an interesting news - Cuba Declares Windows an Oppressive Security Threat, Develops Their Own Version of Linux

Article Global Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Eli Pets

chin yee

3 Comments

  1. It would ve be a very useful article, if i knew what version of access is all about. 2000 or 2003 or what?

    • Thanks for your comment, XCash. I had tried to recall which version that I was using and also I had tried to track the history in my laptop if I can find out something related to the version of Microsoft Access.
      Unfortunately, I had cleaned up everything related to Access once I finished the assignment last few months ago because I really don’t like that application stays in my laptop due to several issues. However, based from the pasted error codes in the blog and the library version (http://allenbrowne.com/ser-38.html#LibVer), I only can assume either 2000 or 2003 and I definitely sure it’s not 2002.

  2. I’m trying to run Access on my Mac OS X Snow Leopard and am getting the exact same results. Any wizard makes the window pop up blank, and none of the control buttons work within the window.. That makes me have to close Access.. This would be awesome if it could work. Have you figured out a fix yet?

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

What is 11 + 8 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)