Businesses that use Microsoft Access eventually begin to struggle against its limitations. Now they have an alternative: Move data repositories to a system that provides better performance and reliability and that is more flexible in how it allows information to be used. NuSphere has the technology you need to follow this course, Gemini the table type for the MySQL database. Together, Gemini and the MySQL database provide a business strength database server that runs under Windows, Linux, or Unix. Gemini provides performance and reliability enhancements such as row-level locking, transaction support, and automatic crash recovery.

By using the MySQL database as a data management platform, you can continue to manipulate your data through Access as a front end if you wish. But you can also exploit your data in other ways, for example, by using MySQL to help you establish or strengthen your web presence. To do this, deploy a web server that handles requests from people who visit your site, and tie it to the MySQL database using a web programming language.

NuSphere Pro Advantage provides all the necessary tools in a single easy to install product. In addition to the Gemini table, it includes the Apache web server and the Perl and PHP programming languages. Perl and PHP both are extremely popular for web programming, and both interface easily with the MySQL database. Included with NuSphere Pro Advantage is NuSphere® PHPEd™, NuSphere’s Integrated Development Environment for PHP-based web applications. The PHPEd IDE is a tool that speeds development time of web-based applications written in PHP. PHPEd is Windows and Linux-based.

Download pdf Migrating from Microsoft Access to the MySQL database