liquidzoo Posted October 6, 2002 Report Share Posted October 6, 2002 I am looking for a program that I can use to edit/save M$ Access .mdb files. I need this for a class I am taking and I hate booting into windows since I got 9.0 configured to my liking. Just curious if there is a prog like that out there in the Linux community. Thanks. Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 6, 2002 Report Share Posted October 6, 2002 Might want to research ODBC. Do a search of the old old board (www.mandrakeuser.org/mub) for odbc. I remember that being asked last year.. Link to comment Share on other sites More sharing options...
DOlson Posted October 6, 2002 Report Share Posted October 6, 2002 I thought that OpenOffice.org and StarOffice were supposed to work with those files. ? Link to comment Share on other sites More sharing options...
bvc Posted October 6, 2002 Report Share Posted October 6, 2002 I thought that OpenOffice.org and StarOffice were supposed to work with those files. ? That's what I heard. Link to comment Share on other sites More sharing options...
mystified Posted October 6, 2002 Report Share Posted October 6, 2002 The only thing I know of is exporting your data in Excel format and then using one of the Linux spreadsheet programs like KSpread. I used to work exclusively with Access databases and using Excel was my preferred way of looking at data anyway. Link to comment Share on other sites More sharing options...
liquidzoo Posted October 7, 2002 Author Report Share Posted October 7, 2002 you're right, it would be easier to look at the files in Excel format, but that's not why I need the program. I need to open and change an Access file for a class I'm in. I have looked at Open Office, but that doesn't have what I need. Haven't tried Star Office yet. I will run a search on the old board and see what I can come up with. Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 7, 2002 Report Share Posted October 7, 2002 Some other search topics to check out are mysql, odbc, "microsoft access", linux, ibm I'm guessing abit since I do database programming on windows, but if you can get odbc installed, then you can use mysql to open a connection through odbc to the access database. Had a thought (yes it hurt!) Check out www.freshmeat.net... here's an example.. http://freshmeat.net/projects/mdbtools/ Use the search engine to get what you need and try to find a project that has utilities so yoiu don't have to reinvent the wheel.. Link to comment Share on other sites More sharing options...
liquidzoo Posted October 7, 2002 Author Report Share Posted October 7, 2002 Thanks for the tips. I found what I was looking for. Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 7, 2002 Report Share Posted October 7, 2002 If you don't mind, share it with us. Never know :wink: Link to comment Share on other sites More sharing options...
liquidzoo Posted October 7, 2002 Author Report Share Posted October 7, 2002 I followed your links and downloaded the mdbtools from freshmeat.net. Works just great for what I need it for. On another note, though, it turns out that I had to use winblows anyway. Guess I should have read the assignment a little more carefully. Damn M$ bias. Link to comment Share on other sites More sharing options...
Cannonfodder Posted October 7, 2002 Report Share Posted October 7, 2002 Not a bad thing. You will get windows experience there and linux experience on your own. Now when you get a job someday if the opportunity arises to use linux to do a windows job, you will know how? *gosh* Link to comment Share on other sites More sharing options...
zero0w Posted October 7, 2002 Report Share Posted October 7, 2002 This is nice stuff, thanks for the link. On a side note, Open Office does not handle MS Access files or database right now. In the future version it will (likely) support direct access to MySQL database. If you do want to use databse in OO now, you can check these articles at PCLinuxonline: OpenOffice.org sites OpenOffice.org 1.0, ODBC, and MySQL 'How-to' Link to comment Share on other sites More sharing options...
johnnyv Posted October 8, 2002 Report Share Posted October 8, 2002 yeah OO supports odbc i have looked at that article before would much rather not use odbc. Your only easy option's in linux that i know of at the moment is to use PHP/MySQL/Apache setup but thats not dynamic which can be a problem, but it is very usefull for alot of things. html -> printing can be a bitch as html was not made to be a good language to print from. In which case you can use freepdf www.fpdf.org which is a php class that you can generate pdf's. pdf's being good for printing as pdf is derived from postscript. Static html as i said can be a problem in some situations you can make webpages appear fairly dynamic with javascript but in some cases that isn't enough. In which case you would need to use something like java, c, c++, or php-gtk. If you know php and nothing else php-gtk would be your best bet. you can of course use a mixture of the webpage/app. If there was an access for linux would you want to use it? access is a terrible database. Link to comment Share on other sites More sharing options...
BertoldK Posted December 30, 2002 Report Share Posted December 30, 2002 As this mdbtools seems to be just what I need, I downloaded a rpm package of mdbtools. When trying to install it (coubleclick on downloaded file, rpmdrake starts), I get a message that libreadline.so.4 is missing. Found this, tried to install the rpm, get message that libc.so.6 is missing. I fear I can continue this way ad infinitum. Was this procedure that I used (download rpm, double click) too simple? I use Mdk 9.0. Can anybody give me a hint how to proceed? Link to comment Share on other sites More sharing options...
Counterspy Posted December 30, 2002 Report Share Posted December 30, 2002 Find out where the missing file is from and download it using http://www.rpmfind.net in terminal mode as root. Do not use urpmi but rpm -Uvh instead. If you need the program then it is worth getting the required files. If you end up with a circular dependency issue install them all on one line as in rpm -Uvh xxxx.rpm yyyy.rpm zzzz.rpm. If the line is longer that 80 characters, just keep typing without a break. Counterspy Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now