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 08-20-2003, 03:12 PM   #1
TotalNoob
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
tcaptain
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 files...so 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
kev82
Senior Member
 
Registered: Apr 2003
Location: Lancaster, England
Distribution: Debian Etch, OS X 10.4
Posts: 1,263

Rep: Reputation: 50
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
TotalNoob
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 Openoffice.org 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
zopista
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

Martin
 
Old 08-21-2003, 11:27 AM   #6
tcaptain
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 use...so 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
tangle
Senior Member
 
Registered: Apr 2002
Location: Smithville, TN
Distribution: Slackware
Posts: 1,745

Rep: Reputation: 71
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.

http://mdbtools.sourceforge.net/
http://sourceforge.net/projects/odbcsock/
http://www.sidespace.com/products/universql/
http://www.upoint.net/myscripts/tablepub.htm
 
  


Reply


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


All times are GMT -5. The time now is 12:47 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration