Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Microsoft Access for a Mac
- Thread starter sf129
- Start date
In addition to filemaker, which is a great suggestion, you could also use MySQL if they are running OSX.
PT
PT
brightstar
Technical User
- Sep 20, 2002
- 233
jees is that it?
i looked at filemaker and it was rubbish.
flat file, no window to look at overall relationships or lay out. not equivalent to access at all.
free, anonymous advice provided by the whole world
i looked at filemaker and it was rubbish.
flat file, no window to look at overall relationships or lay out. not equivalent to access at all.
free, anonymous advice provided by the whole world
TimRegester
Technical User
I doubt there is an application that will do what you want.
But lately discussions I have had have led me to the conclusion that full relational databases with heirarchical structures may have had their day. With faster processors and disk i/o accessing a record in a large flat file database may be as quick if not faster than using a relational database with keys and relationships etc.
After all the relational database model was used to speed up finding records in databases due to hardware limitations. If the hardware is now x times faster it is perfectly possible that keys may actually slow down finding the recordset needed.
This almost certainly does not apply to huge networked and mainframe RDBMS.
So I would look at mysql, you already have the sql if you have access skills. There are tools to manage it and php can provide the front end.
Just a thought.
But lately discussions I have had have led me to the conclusion that full relational databases with heirarchical structures may have had their day. With faster processors and disk i/o accessing a record in a large flat file database may be as quick if not faster than using a relational database with keys and relationships etc.
After all the relational database model was used to speed up finding records in databases due to hardware limitations. If the hardware is now x times faster it is perfectly possible that keys may actually slow down finding the recordset needed.
This almost certainly does not apply to huge networked and mainframe RDBMS.
So I would look at mysql, you already have the sql if you have access skills. There are tools to manage it and php can provide the front end.
Just a thought.
kylebellamy
Programmer
Can Filemaker convert a relatively simple Access database. I have one that is used to store the MSDS data for the plant and want to switch to my Mac to do them.
ObviousTroll
Programmer
Kyle,
Your best bet would be to export the Access DB as a tab- or comma- separated value file and import that into Filemaker.
I've done that for importing simple databases into AppleWorks and Excel.
Your best bet would be to export the Access DB as a tab- or comma- separated value file and import that into Filemaker.
I've done that for importing simple databases into AppleWorks and Excel.
brightstar
Technical User
- Sep 20, 2002
- 233
and what about complex databases? exporting flat files to filemaker, i assume, will lose all your coding and relationships?
is there NOTHING other than filemaker? nothing with a bit more brains to it?
free, anonymous advice provided by the whole world
is there NOTHING other than filemaker? nothing with a bit more brains to it?
free, anonymous advice provided by the whole world
kylebellamy
Programmer
Well, in my case there are no relationships, just a long list of entries that I pull the active ones and print labels.
ObviousTroll
Programmer
Brightstar,
If you need and RDBMS, then look at MySQL - but short of setting up Apache with PHP, there's no front end for it on the Mac or any other platform.
If you need and RDBMS, then look at MySQL - but short of setting up Apache with PHP, there's no front end for it on the Mac or any other platform.
- Status
Similar threads
- Locked
- Question