How easy is it nowadays to migrate an Access application to Linux?
I'm getting rather fed-up with trying to maintain an Access 97 application on Windows 2000 and migrating to Linux might be the answer.
In the end, yes, maybe. It's actually quite a simple application and an HTML/PHP front end would be a brilliant idea. However a 'quick and dirty' bodge for the moment would be useful too!
[Andy] Previously I made a living out of developing MS Access systems for corporate clients but got fed with the whole support and rollout issues of having one client application per PC.
Over the last 3 years my company has developed a case tool that will take an MS Access database design and produce a MySql schema along with all the html, php and sql associated with each table. As far as speed of development and remote supporting database applications we haven't looked back. An example of one of our PHP applications can be found running at www.go4watches.com.
MS Access is an excellent tool for designing databases but moving to a browser front end and database on a web server is the way to go for any system that has more than one user.
Andy Jackson