Convert Access

[cocoonfx]

Hello

It been a while since i have been on the forum. I developed a database last year and since then i have moved to a MAC.

I would like to know if there is a quick and easy way of converting a database to application which works on any PC or MAC which does not have access?

 

[Moniker]

Look for Filemaker drivers for Access on Google. Filemaker is a popular DB used on Macs. If you're not using that, you could use all CSV file links as tables (store your Access tables as CSVs, or comma separated values, which are just text files with the data in them), and both a PC and a Mac will read those. As for the queries, forms, reports, etc., you're SOL in converting Access to Mac. If you are using a Mac DB program of some sort, see if it has Access drivers in it. That may allow for at least the tables and queries. The forms, etc. will still need to be recreated. The CSV method will only get the data.

Why switch to a Mac though? Are you trying to make sure nothing useful gets done?

 

[tehNellie]

In terms of a quick, easy solution that works cross platform I'm struggling a bit, one solution that would involve a fair bit of initial setup is to use something like mySQL as a backend with a Java front end application.

the Mysql component can either be installed locally or onto a server and in theory the Java app should work across windows, mac and unix/linux clients.