Find the answer to your Linux question:
Results 1 to 4 of 4
I have just created an MS Access 2013 database with my Windows computers in my home and I would like my Ubuntu Linux computer to participate in the databse. I ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2012
    Posts
    9

    Linux database needed


    I have just created an MS Access 2013 database with my Windows computers in my home and I would like my Ubuntu Linux computer to participate in the databse. I need an Ubuntu Linux database that can read and write MS Access 2013 dabases.

  2. #2
    Just Joined!
    Join Date
    Oct 2013
    Posts
    47
    go to URL : dev.mysql.com/doc/refman/5.1/en/connector-odbc-examples-tools-with-access.html

    MySql can access MS tables and vice versa.

  3. #3
    Just Joined!
    Join Date
    Jul 2012
    Posts
    9
    I see, does this mean the drivers are comaptible with Access 2000, 2003, 2007, 2010 or 2013. Microsoft tends to change the format the data files with each new version of their software so that you can not be compatible.

  4. #4
    Just Joined!
    Join Date
    Oct 2013
    Posts
    47
    Hello;

    OK perhaps I misunderstood your requirements. You want a database that works on both linux and windows. You are desperate to make sure it will port between MS versions... even MS programs misread MS file formats!? So you're not going to spit out the data once to the new system, you are going to keep a linux database and a Windows database ongoing? You can always export as an MSV file and import same if the format has problems.

    Are you sure you don't want to adopt an open source program like postgresql or mysql that can work seamlessly on pretty much any platform? No conversion headaches. These have windows and unix versions of the same program on separate server sides. You could have a linux server and access it from the network from a windows client or vice versa.

    That might make a steeper learning curve for a new database compared with over and over fixing format conversion problems. There is a trade off, either could work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •