Help get me off Access!
Does anyone know of an Access like program for mac that will also be cross platform compatible? I tried Filemaker but I just hate the fact that every "table" is really its own file - I like the Access style where you see all the tables in one file. I also kind of think that Access is much more versatile and can do more, in terms of my needs, than Filemaker can.
Anyone have any good suggestions?
Anyone have any good suggestions?
Comments
Originally posted by running with scissors
are you using it for the web? if so why not use mysql with phpadmin.
Forgot to say, that this is pure internal database, none of it will got on the web.
Originally posted by Shanksta
Forgot to say, that this is pure internal database, none of it will got on the web.
filemaker would be the closest thing i can think of. you might also take a look at 4D, but it may be overkill for what your doing.
Originally posted by Shanksta
The only thing I absolutely HATE about FileMaker is that every file is separate - I love the Access ability to have everything self contained - if there is a view option for FileMaker or if anyone knows about any updates or hacks I would really appreciate it.
What do you mean by a view option?
But you should take a look at 4D - it's more 'database like' than FileMaker.
Originally posted by Shanksta
Does anyone know of an Access like program for mac that will also be cross platform compatible? I tried Filemaker but I just hate the fact that every "table" is really its own file - I like the Access style where you see all the tables in one file. I also kind of think that Access is much more versatile and can do more, in terms of my needs, than Filemaker can.
Anyone have any good suggestions?
If you weren't looking for cross platform compatibility, check out Paradox.
In a previous thread I posted what it might contain. It is suspicious that nothing has been heard about it by now.
Oh...here's the link.
I think from your comments that you are experimenting with filemaker. So I am going to give you a quick conversion turn around for it. Sorry if you already know it and have done this.
1. Go to the Access and export all your tables as excel sheets.
2. In Filemaker just say open and point it to the excel sheets.
3. After all your tables are inported in their own file create relationships by going to File->relationships between the Filemaker files.
4. If you Do not know what your relationships are just print out the relationships from Access.
5. After you do all of this in Filemaker you can simply export it using freeware FMProMigrator and play with it in MYSQL. If you need a browser based interface for MYSQL use phpMyAdmin and if you want an application use CocoaMysql both are freeware.
Try Filemaker's scripting language if you need more power. I think you will find the idea of not having reports and queries and form and tables seperate from each other sometimes is a blessing. And controlling the output formats are very easy. Getting on the web only needs connection and two checkmarks.
If you need more information there are thousends of tutorials around.
Good Luck
Jay
Only Jobs would be able to keep something like this a complete secret.
I can't for the life of me remember where I read that, though.
For now, though, I'd have to agree that mySQL with <insert GUI front end here> is the best bet.
-John
He's not allowed to say much about "FileMaker Next" (they're not calling it FileMaker 7 yet because they haven't decided whether to name it that yet), but he did tell me that it will be a very major upgrade that will basically incorporate all the features people have been asking for all these years, moving FileMaker above the "toy" status and making it much more competitive with other, professional databases.
That's really all he told me though... most of what he told me was over my head.