Yet another email from me.
I need a app for linux which is compatable with MS access and provides most of the same functionality as Access. The reason being is my next college assignment is to design a database in access which is handed in in access format. unfortunatly my idea of a shell script using text files and sed/awk/grep didn't go down well :o(
So can anyone suggest a suitable app?
Thanks
D
__________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
David Freeman wrote:
Yet another email from me.
I need a app for linux which is compatable with MS access and provides most of the same functionality as Access. The reason being is my next college assignment is to design a database in access which is handed in in access format. unfortunatly my idea of a shell script using text files and sed/awk/grep didn't go down well :o(
are you talking about using access as a backend database, or a frontend design tool ?
As far as I know you can get odbc postgress and mysql windows drivers. This allows you to import/export a mysql database into an access database (and vice versa ;).. I have never tried this to take with a pinch of salt, but all of the stuff I have read says this is possible. this woiuld allow you to write a mysql/postgress system, then import into access for your assignment...
As a front end database design tool, I have to say that I haven't found anything that comes close to access's features.... that's not to say there isn't one ;)...
hth Sz
So can anyone suggest a suitable app?
Thanks
D
Neill Newman wrote:
[SNIP]
As a front end database design tool, I have to say that I haven't found anything that comes close to access's features.... that's not to say there isn't one ;)...
We use MSAccess to design DBs, and then we have a macro to spit the schema out in SQL, which we then run into the DBMS of choice (postgres for big stuff, mysql for noddy stuff, so mostly mysql :^))
Cheers, Laurie.
Have you thought of using interbase which is now open source, that has an ODBC link so you can access it wfrom windows while it runs under linux.
Owen Synge
On 05-May-01 Neill Newman wrote:
David Freeman wrote:
Yet another email from me.
I need a app for linux which is compatable with MS access and provides most of the same functionality as Access. The reason being is my next college assignment is to design a database in access which is handed in in access format. unfortunatly my idea of a shell script using text files and sed/awk/grep didn't go down well :o(
are you talking about using access as a backend database, or a frontend design tool ?
As far as I know you can get odbc postgress and mysql windows drivers. This allows you to import/export a mysql database into an access database (and vice versa ;).. I have never tried this to take with a pinch of salt, but all of the stuff I have read says this is possible. this woiuld allow you to write a mysql/postgress system, then import into access for your assignment...
As a front end database design tool, I have to say that I haven't found anything that comes close to access's features.... that's not to say there isn't one ;)...
hth Sz
So can anyone suggest a suitable app?
Thanks
D
-- Open source solutions at http://www.entora.co.uk/
alug, the Anglian Linux User Group list Send list replies to alug@stu.uea.ac.uk http://rabbit.stu.uea.ac.uk/cgi-bin/listinfo/alug See the website for instructions on digest or unsub!
Date: 07-May-01 Time: 20:10:17
-
David Freeman -
Laurie Brown -
Neill Newman -
oms101＠freeuk.com