Printable View
Hi all,
I have a couple of MS Access databases that are on my server and Im wondering if I can access and run them from linux. Ive seen the likes of kexi, but does it work with opening mdb's?
Just wanted to check what the best alternative is before downloading, thanks!
Honestly I never found a working solution for direct access. If someone responds with one I'd be happy to have it. What I've done is flatten Access files to Excel then OpenOffice (or guess it's Libre Office now) can read them fine. Not every Access database converts to Excel without hiccups though. In that case, I VM a XP instance just to get what I need from it - not ideal I know.
I agree w/ the above poster, Open Office has Base Office which is the counter program to MS Access. Don't forget that there is Libre Office Base as well.
Would Base work in accessing a mdb program database on my server? I might have to give it a try.
Unfortunately converting it to excel isnt an option as it is quite a complex program/database/form. Virtualisation isnt an option either as Im thinking of doing this on a Raspberry.
If you are going to a Pi (YAY, glad someone else is playing with it!) - you may consider Access to MySQL convert?
If I can get hold of one. It is really annoying me that the distribution of the Pi has been so poorly thought out. I don't know if it is deliberate or just a terrible blunder?Quote:
Originally Posted by trilarian
But when I do get hold of one (or more), hurrah! Have you got one yet by the way? I've got quite a few different thoughts for it. If it handles video quite well, I could use it in conjunction with a 2.5" HDD for a portable media player such as taking films and music to a friends house or when I go away.
One other idea I had, is to make it truly portable. I might try to scour a few places to pick up damaged netbooks/phones with OK screens and then since they claim the Pi can be powered by a few 1.5v batteries, I was thinking about wind up radios, clocks and torches and whether it would be possible to power a Pi with that energy?
Thanks for the linky, I'll boot in to win7 and give it a shot. When I first started the databases years back, I just used mdb's as they were very easy.
I signed up late, so haven't received one yet. My friend was one of the first to sign on though and has his. So I get to play with it in short intervals of time if I'm over. Though I dislike the way it is being handled, I completely understand. They simply did not predict its massive popularity. Hell their site was down for nearly a month like it was under DDoS attacks simply by people rushing to buy them.
I think they were aiming for schools to get kids interested early on, breeding new engineers and programmers. The mod and DIY community jumped on board swiftly.
I'll be patient. I have a number of proto-boards like a 68HC11 and Dragon12, as well as single chips like PICs and 8088s. So its not like I can't play with projects in the interim.
hope you will do same things again :)
I had a similar issue, what I ended up doing is purchasing RealBASIC (now I use RealStudio) and then I use SQLite3 as the underlying database. By doing this I have a solid, fast and cross platform database application that comes with a killer RAD GUI that's pretty easy to use.
Also the application I wrote to replace the Access database is 1000 times more stable AND robust. Dunno... it got me a raise and a new office.