My first encounter with CFMX was as a member of the prerelease beta team. I signed up because I thought that Mac OS X was likely a part of the beta. It was not.
When I expressed my disappointment, some Macromedia beta members (particularly Jesse Noller) expressed the opinion that a CF 'Nix product could probably be made to run without too much effort.
I asked about porting a Windows version (I did not have Linux). The answer was that because of file system differences, os facilities (such as the registry), script files, organization, etc. it would take a lot more work and was a lot less likely to be successful.
The Linux port was the recommended approach.
My impression is that you could spend a lot more $ and hours trying to port a win version that may not work -- Linux is virtually free.
As to the need to run MS-Access on any non-windows platform:
This is a common request.
Here's the short answer: No, MS-Access runs *solely* on the windows platform.
No one has developed a driver to interface MS-Access because all the logic of MS-Access is in the ODBC driver, itself -- they would be converting MS-Access to the other platform. I don't know if MS will not allow this, of if they just have made it too expensive -- but it is not available.
It should be noted that MS-Access is a poor choice for a production online database, for lots of reasons. It was not designed for that purpose; and as few as 1 concurrent user can lockup a MS-Access database, requiring a lot of fiddling to get it going again.
That said, because of its ubiquity, MS-Access is an excellent vehicle to use to create an online db with a more robust RDBMS. Also, to periodically create a copy of an online db for offline use.
With that in mind, there is a way that you can interface CFMX on a non-windows (Mac OS X, Linux, Unix, etc.) platform with MS-Access databases on a (real or emulated) windows platform.
The procedure for doing this is too complex to cover here, and it is not free.
At the end of Part 4 there will be a poll of the next topics tha`t are available. Interfacing MS-Access databases is one of these topics.
So, if the interest warrants, it will be covered in the near future.