MS Access lookalike

[mikey69]

Anyone ever come across a MS Access lookalike that works on Linux? It's a real gap and short of learning C++ and writing a MySQL interface I can find no solution.

Access makes all things possible. It even makes them intelligible

 

[flugh]

Check out 'rekall' at

http://www.rekall.a-i-s.co.uk/

I haven't messed with it much beyond the initial download, but it looks promising. Even claims to be able to generate reports a la Access.

----
JBR

 

[thedaver]

Mikey69 wrote "It's a real gap and short of learning C++ and writing a MySQL interface I can find no solution."

There are 100 books on using Perl or PHP to talk to MySQL or even Access database backend using ODBC.

I don't know what your development goals are, but you might have gotten some back information that lead you to believe that C++ was needed.



Surfinbox.com Business Internet Services - National Dialup, DSL, T-1 and more.

http://www.surfinbox.com/business/

 

[fdalmoro]

I asked this same question some time ago, basically it can be done with MySQL and OpenOffice.org. OpenOffice provides the front end but you need something like a basic install of MySQL to make it work which is not that bad. I never messed around with it but hope it helps.

http://www.unixodbc.org/doc/OOoMySQL.pdf

Fernando

 

[jstreich]

In addition to OpenOffice.org, there is also a great tool (not at all like ACCESS, but easy to work with) called MyAdmin. It's PHP so it does require Apache, MySQL and PHP. The other route is to use a JAVA program. The JDBC doesn't care what database it's using as long as it can talk to it, so most/all Java database programs should work alright with MySQL. Failing that, you could issue SQL calls from the command line to the database...

 

[mikey69]

Thanks for all the comments. I wondered about Rekall and will have a look at it. A bit more background: I live in South Africa and have developed a fairly comprehensive management system to meet the special needs of a bakery, which has the government as a significant customer. The SA government is making noises about tax breaks for open source software and I'm trying how best to respond. I also like the thought of open source.

Access makes all things possible. It even makes them intelligible