DBForms from MS Access to PHP + MySQL

DBForms from MS Access to PHP + MySQL is an effective application which allows you to convert MS Access forms to WEB pages and Microsoft Access tables to MySQL database.
Using the modern and the popular web technologies, as AJAX, we fully changed data mapping from Access database to web forms. These up-to-date combinations of technologies are also used by GMail and Yahoo web-based email services. Ajax allows users to receive database information without overloading web pages as before, provide significant time economy and improvement performance.

Supported controls

DBForms from MS Access to PHP + MySQL supports the following elements in MS Access forms:

* Label
* Images as OLE types
* Images as form elements
* OptionGroup
* TextBox
* ListBox
* ComboBox
* CommandBox
* Line
* Tabular Control
* Subforms

Now you can easily convert forms (Single Form, Continuous Forms, Datasheet), and their elements to Web page and filling form fields with data from the fields of your Access tables. During the conversion, controls' position, colour pallet and fields type are accurately converted. You have the opportunity to place your forms on a Web page directly through FTP connection or save your forms to a local folder on your computer for future uploading to FTP.

High speed data conversion and performance
Try it now and make sure that it’s true! DBForms from MS Access to PHP + MySQL establishes a direct connection to source and destination databases as well as through FTP server connection. Also you have an opportunity for saving your forms to a local folder on your computer for future uploading to FTP. Thanks to improved quality of conversion, data is transferred much faster and more accurate in comparison with lots of universal converters which use ODBC or ADO. It is developed exactly for solving your problem with minimum effort and time!

Preverification of possible conversion errors
Verify possible conversion errors before the conversion process gets started! To prevent is better than to correct! Our tool displays errors and potential problems with your table objects beforehand. Some errors that could bring to the conflict on a destination database are easy to eliminate by a small reconfiguration of the conversion process issues in one touch.

Safe data conversion and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBForms from MS Access to PHP + MySQL supports all MySQL server and MS Access data types (including `BLOBS` and `OLE Object` packages). Primary keys and indexes are supported in the best way.

SQL queries conversion from one database dialect to another
It is known that SQL queries translation from one database dialect to another can do the migration process more accurate. Now working on database conversion you don’t need to lose your valuable time trying to learn the differences in SQL dialects. DBConvert tools can convert SQL queries AUTOMATICALLY. No knowledge required on your part.

Update, Insert and Delete functionality in WEB pages
This functionality allows you to insert, update and/or delete data in forms at WEB pages manually. All your modified data will be stored in the database automatically so it will be neat and organized.

Workaround problems with firewalls and access rights
Use our workarounds as “MySQL Dump” and “PHP Script” if you don’t have a direct access to MySQL server! “MySQL Dump” can be used if you have no direct access to MySQL server, but can execute SQL-scripts, for example through phpMyAdmin or other tools. “PHP Script” is used if you don’t have a direct access to the MySQL server, but have an ftp and PHP access. DBForms from MS Access to PHP + MySQL generates a PHP-script that contains database info inside and can be executed on the server to put database there.

Full UNICODE architecture support
DBForms from MS Access to PHP + MySQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.

Savable sessions
Save your sessions and use them again if you do not want to loose time for configuring source, destination database and other customizations for conversion process.

Command line mode
Run DBForms from MS Access to PHP + MySQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.

User-friendly interface
User-friendly interface is the outcome of the combined efforts of our team in the field of software usability plus Graphic User Interface design. Working with the converter is specially divided into several stages so the most complex issues of the conversion process are broken down into manageable parts. All documentation is provided with the software for your convenience.

Try for free
You are invited to use our program for as much runs as you like but our free trial version allows you to convert the first 5 forms and the first 10 records from each table. Instead of wasting a lot of time and effort trying to convert your data by yourself, we encourage you to try our new high-quality converter and place your MS Access forms on your web-page simply. You will get a whole range of benefits: fast conversion, excellent performance and it is a real pleasure to work using DBForms from MS Access to PHP + MySQL.

Features

* Conversion of forms and their elements, filling form fields with data from the fields of your Access tables;
* Support for the following elements in MS Access forms:

- Label
- Image
- OptionGroup
- TextBox
- ListBox
- ComboBox
- CommandBox
- Line
- Subform
- Tabular Control;

* Unicode Support/Connection character sets support:

LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, UTF8 (unicode charset);

* Primary keys and Indexes support;
* AJAX technology support;
* Update, Insert and Delete functionality in WEB pages available;
* SELECT queries support;
* Advanced customization options:

- rename forms caption
- partial selection for database objects to be converted.
- detection of possible conversion errors at customization stage;

* Sessions support - all your settings can be saved and restored later;.
* `ENUM` and `SET` MySQL database types support;
* `GUID` Access database type support;
* `OLE Object` packages support;
* Interactive (GUI) mode / command line mode;
* Automation of the conversion process with task scheduler;
* During conversion elements' position, colour pallet and fields type are saved;
* Saving forms to a local folder or your WEB - directory;
* Conversion of simple formulas in EditText elements;
* Saving data into a MySQL Dump, PHP script for export to MySQL database;
* Support for MS Access Work Groups;
* Support for AutoIncrement (AutoNumber) fields conversion;
* Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
* Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump;
* 1-year free upgrades.

Requirements

* Windows Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
* PHP5 and higher + MySQL 5 and higher
* At least 32 MB of RAM
* Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script ).
* You need to have PHP and MySQL installed and configured at your server.

Important notices

* Does not convert macros.
* Does not support calculated fields.
* Does not convert queries with parameters.
* Does not convert system (hidden) tables.