LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-17-2013, 12:06 PM   #1
Linux31
Member
 
Registered: Aug 2004
Posts: 296

Rep: Reputation: 30
Smile Migrating MS Access DB to Libre Office Base or MySql


I have a couple of databases in MS Access running on Win200SP4 that I would really like to move to the Linux side. The forms have embedded graphics so it's not just a case of exporting things as a xls or comma-delimited file without losing the forms and the graphics.

Everything that I've read says that there is no way to just import things seamlessly into Libre Office Base or MySql or convert the .mdb files and certainly no way to save the forms. Basically, I would have to re-build everything from scratch.

Say it isn't so!!

Can anyone suggest a better way than that or even a good book on how to create this kind of database in LO?

Thanks for any help that you can provide.
 
Old 02-17-2013, 06:22 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,268

Rep: Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522
Quote:
Originally Posted by Linux31 View Post
I have a couple of databases in MS Access running on Win200SP4 that I would really like to move to the Linux side. The forms have embedded graphics so it's not just a case of exporting things as a xls or comma-delimited file without losing the forms and the graphics.

Everything that I've read says that there is no way to just import things seamlessly into Libre Office Base or MySql or convert the .mdb files and certainly no way to save the forms. Basically, I would have to re-build everything from scratch.

Say it isn't so!! Can anyone suggest a better way than that or even a good book on how to create this kind of database in LO?
Well, the part about forms is true...Access forms aren't really database records...just a bit of front-end stuff to let you access the data. Not sure where your embedded graphics are (in the form, or in the DB table?), but you should still be able to export the Access data itself. If the pictures are part of the database now, export those (somehow...sorry, don't know much about Windows/Access). The good news is, there are many examples of how to import data and pictures, into a MySQL database, such as this one:
http://support.tigertech.net/mysql-load-image

There are also probably programs on http://www.hotscripts.com that will let you hook into a MySQL database and browse pictures/edit data through a webpage (PHP most likely). MS Access is only really good for light-duty, and once you get migrated into a 'real' database (MySQL, Oracle, PostgreSQL, etc.), you'll find that you have a lot more scalability and flexibility. But, the migration will probably be a bit of a pain. I do this sort of thing all the time, and have never had a client say they were sorry they did it afterwards.


There are commercial tools you can buy that can help:
http://dbconvert.com/convert-accessf...-web-mysql.php
 
Old 02-18-2013, 07:59 AM   #3
Linux31
Member
 
Registered: Aug 2004
Posts: 296

Original Poster
Rep: Reputation: 30
Thanks for the help. I will definitely check those links. My databases aren't anything fancy. One, for example, is an inventory of my collection of old science fiction paperbacks. The embedded graphics are scans of the neat old cover art from that era. Mainly, it helps me from mistakenly buying the same book again.

I'd really like to get them into something Linux-based rather than linking into Access since then that would be one more Win program I could discard.

Thanks again for the information.
 
Old 02-18-2013, 10:49 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,268

Rep: Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522Reputation: 6522
Quote:
Originally Posted by Linux31 View Post
Thanks for the help. I will definitely check those links. My databases aren't anything fancy. One, for example, is an inventory of my collection of old science fiction paperbacks. The embedded graphics are scans of the neat old cover art from that era. Mainly, it helps me from mistakenly buying the same book again.

I'd really like to get them into something Linux-based rather than linking into Access since then that would be one more Win program I could discard.
Thanks again for the information.
No problem, and check hotscripts.com. There may already be an inventory type program for such things (perhaps for DVD's or other collections), that already do what you want, and use MySQL.
 
  


Reply

Tags
lo base mysql ms access


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unoconv Convertor for RHEL 6 : Libre office & open office utility vishwajeet jagtap Linux - Software 0 02-15-2013 10:44 AM
libre office take up whole window. casperdaghost Linux - Newbie 4 02-04-2012 09:44 AM
Libre Office database jdtiede Linux - Software 1 12-11-2011 05:22 AM
LXer: Libre Office Initial plans for the free office suite [German] LXer Syndicated Linux News 2 11-14-2010 06:14 PM
Migrating db relationships from Access to MySQL crashsystems Linux - Server 2 02-10-2007 01:21 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:37 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration