How can we use MS Access DB in linux??

peddip · 06-12-2009, 07:05 AM

Hi All,

I have a DB created using MS access in widows and now i'm trying to host a website using tomcat in Linux where i'm using this DB. When i configure tomcate in widows and use this DB my website works fine, but when i configure tomcat in linux and try to browse my url, it throws an error. It opens my login page, but when i give details it has to fetch the Data from DB and go to another page. But in linux its unable to access the DB.

Can any one suggest me here?

Thanks...

TB0ne · 06-14-2009, 12:09 PM

Quote:

Originally Posted by peddip

Hi All,

I have a DB created using MS access in widows and now i'm trying to host a website using tomcat in Linux where i'm using this DB. When i configure tomcate in widows and use this DB my website works fine, but when i configure tomcat in linux and try to browse my url, it throws an error. It opens my login page, but when i give details it has to fetch the Data from DB and go to another page. But in linux its unable to access the DB.

Can any one suggest me here?

Thanks...

Access doesn't work in Linux, period. Convert your database to something in an open format (like Postgres, MySQL, etc.), and use it.

peddip · 06-15-2009, 12:03 AM

Thanks TBone,But could let me know how can i convert it in to mysql?

chrism01 · 06-15-2009, 12:07 AM

This looks interesting: http://www.bullzip.com/products/a2m/info.php
NB: never tried it myself, so use at your own risk

TB0ne · 06-15-2009, 07:32 AM

Quote:

Originally Posted by peddip

Thanks TBone,But could let me know how can i convert it in to mysql?

Many different ways. You could get a Windows box going, and export the data into a comma (or tab) separated value file, and import that into MySQL, or use some of the tools that are easily found through Google. chrism suggested one...some others on the Google list of "convert access to mysql"..

http://www.howtodothings.com/compute...-to-mysql.html
http://dev.mysql.com/tech-resources/...microsoft.html

From what I read on the second link on the MySQL site, you can do a MySQL export from Access...