MS ACCESS type Database on Simply MEPIS?
Not quite... But there is a nice little alternative.
From time to time, people ask on the forum about a simple database app for MEPIS that doesn;t involve messing with SQL. Something more like MS Access. Here it is (again).
The Beta Version of OpenOffice.org 2.0 is currently at "OpenOffice.org Developer Snapshot Build 1.9.m95", available for download at openoffice.org website.
When you download the package, and extract it, you will have a folder of rpms.
If you run (as root)
alien -k *.i586.rpm
you will have some deb packages.
If you then do
dpkg -i --force-overwrite *.deb
It will install.
running
/opt/openoffice.org1.9.95/program/soffice.bin
will open the program workspace.
From there, select new database and you will find it quite simple to create a nice database using wizards.
Create a new link to application using the above command and you will have a FAST and enhanced openoffice available.
This is a BETA and is not stable, however I have been using the betas since they were released and have only minor glitches.
RossD.
Unfortunately, it isn't.
Unfortunately, it isn't. Knoda (at least the 0.7.3 that I have installed) doesn't work unless you can connect to a mysql server. On my system it simply fails to connect, even though mysql is running.
This is what other people are trying to avoid also.
Also it is messy trying to set up a database using knoda on Linux, then make it work on Windows.
The openoffice.org 2.0 database format should be portable, with any luck.
RossD
Quote: I would have liked
Quote:
I would have liked to use MySql or similar but the restrictions placed by my Uni meant that i could only use Access
End Quote
I had a similar problem with Uni. I'm 51y.o. and decided to do a few units of an IT degree just for fun.
All the course work, and all the books were designed around MS ACCESS.
I dug out a copy of StarOffice that still had the relational database in it, and used that. Did the entire set of Word, Access, Powerpoint and Access using StarOffice and Openoffice omn Linux.
They never knew the difference, and I scored a HD with 85.25%.
I lost 6% over a fight with them when I proved they had marked an answer in the Word unit incorrectly. They offered to mark me back up again, and I told them to re-write their exam and give the marks to students they had failed on those questions.
Anyway, It was an interesting experiemnt. The database we had to create was relational, and fortunately, for that unit we had to provide printed results, so as I said, they didn't even know until I gave them a hard time about using proprietary software in teaching.
More recently, my wife had to do a course through her employer on Paint Shop Pro. She then asked me to buy PSP 8 and install it on her Windows partition.
She already had an earlier version, plus GIMP in Windows and Linux, so I asked her why. She pointed out that PSP8 has 'Picture Tubes".
I showed her how to make a brush in GIMP from a photograph she had. Voila! Gimp Picture tubes...
Then I asked her about the other things she learned to do on the course. It turned out the only thing they did in PSP8 that was not immediately obvious in GIMP, was the tubes.
My entire point with OpenOffice.org Base, is that because it is cross platform, it should be easy to create a portable simple database that is much more convenient than trying to set up a MYSQL one.
RossD.