Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 08-20-2003, 03:12 PM   #1
LQ Newbie
Registered: Mar 2003
Posts: 16

Rep: Reputation: 0
How to open "Microsoft Access DB"

Hi all,

I have run several searches, but my results have not been helpful

Is there any way I can open a Microsoft Access Database (2002) in Linux? I have Mandrake 9.1.

I don't even need to be able to write to the database, just need to view it and search it.

I was sure MS had a Linux viewer, but if they do, I can't seem to find it.

Anyway, Thanks for the help.
Old 08-20-2003, 03:31 PM   #2
LQ Addict
Registered: Jul 2002
Location: Montreal
Distribution: Gentoo 2004 from stage 1 baby!
Posts: 1,403

Rep: Reputation: 45
M$ does not have a "linux" anything...sorry to disappoint you.

However, I believe OpenOffice can access Access db you might want to search their sites (or tinker with the software, I find it pretty good)

I used to have a link on how to do this, but I have not been able to find it for you...sorry.
Old 08-20-2003, 04:13 PM   #3
Senior Member
Registered: Apr 2003
Location: Lancaster, England
Distribution: Debian Etch, OS X 10.4
Posts: 1,263

Rep: Reputation: 51
can't you export all the tables and queries as text, then import them into mysql or some other database server.
Old 08-20-2003, 04:27 PM   #4
LQ Newbie
Registered: Mar 2003
Posts: 16

Original Poster
Rep: Reputation: 0
Hi, thanks for the replies.

Yes, I could do an SQL dump, but I am looking for a way to access the direct database, not just the data.

Although I only need to be able to view the data, the contained MS file gets updated once per day. I basically bring it home every night. So it would be nice if I don't have to take extra steps each and every day to view the data

I am looking into right now, but so far, I have not read anything aboout opening an Access file in the same way you can open a Word and Excel file.

Still looking.

Thanks again for the suggestions!
Old 08-20-2003, 07:06 PM   #5
LQ Newbie
Registered: May 2003
Location: Wellington, New Zealand
Distribution: Debian sometimes, RedHat mostly ... playing with Mandrake on my laptop
Posts: 5

Rep: Reputation: 0
You could create a macro in the access db to export the data to excel. take the spreadsheet home (or email it) and open it with open office

Old 08-21-2003, 11:27 AM   #6
LQ Addict
Registered: Jul 2002
Location: Montreal
Distribution: Gentoo 2004 from stage 1 baby!
Posts: 1,403

Rep: Reputation: 45
TotalNoob: Stick with it. I KNOW there's a way. I'm still digging for that link (I went through my bookmarks BUT I think I had printed this out for future I'm working on it). As SOON as I find it, I'll post it here.

You might always also want to look at UnixODBC (google for Unix ODBC and you should find it) because then, you could connect through OpenOffice and that and that might let you access your .mdb. (I'm grasping at straws here with a weak memory).
Old 08-21-2003, 11:37 AM   #7
Senior Member
Registered: Apr 2002
Location: Arbovale, WV
Distribution: Slackware
Posts: 1,761

Rep: Reputation: 78
You might want to try looking at these. I had an app once that let me view the tables and such in access from Linux, but I forget what it is called.


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
New SQUID user: How to clear the "access.log" and "store.log" automatically? yuzuohong Linux - Networking 2 12-02-2006 06:37 AM
Can you explain the difference between "Free Software (GNU)" and "Open Source"? vharishankar General 5 03-03-2005 10:40 AM
Compiling KDE 3.2.0 - "Can't open perl script "/dcopidlng/kalyptus" linuxgamer09483 Linux - Software 3 04-09-2004 09:25 PM
"X-MS" cant open because "x-Multimedia System" cant access files at "smb&qu ponchy5 Linux - Networking 0 03-30-2004 12:18 AM
need help, on how to access quickly to special characters like "" or ""? Motaro Linux - Newbie 1 12-31-2003 12:53 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:03 AM.

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