Access2MySQL Sync is an effective application which allows you to convert .mdb (Microsoft Access databases) databases to MySQL and MySQL to Microsoft Access , unlike other similar tools, which commonly perform only one-way conversion.

Along with this general functionality, Acces2MySQL Sync supports database synchronization , which allows to avoid the data duplication and more.

The program is extremely easy to use, it is implemented like a common wizard-like application, so even an inexperienced user will be able to work with it.

Employing Access2MySQL Sync you get unlimited web and e-mail support, we are always prepared to help you, so you needn't to worry about it. We appreciate all your feedbacks as well as comments and suggestions.

• Command line mode speed optimized
• Command line bug with spaces in table names fixed
• Additional validation of entered data in wizard
• Bug with MySQL server v4.1.3 fixed
• Garbage symbols in command line bug fixed

• Access2MySQL Scheduler that gives you an opportunity to run any application on a user defined schedule is added.
• Support for OLE Objects ( ability to convert such objects as a Microsoft Excel spreadsheet, a Microsoft Word document, graphics, sounds, or other binary data) linked to or embedded in a Microsoft Access table.
• Ability to select ISAM, MYISAM, HEAP, InnoDB, BDB table types when choosing MySQL destination database.
• A new ability to choose particular tables to be converted. In the case you don't want to convert all the tables, specify only those tables you would like to convert. There is opportunity to copy selected tables either in Wizard mode or launch the copying process through the command line.
• Load the .sav file option when starting from command line;
• Option to display information about copying process;
• Password encryption, when saving your settings to file;
• Support for MS Access Work Groups;
• Query handling improved, support for reserved words and spaces in DB table/field names is added;
• Empty date field are copied properly;
• Support of local time format is added;
• Correct work with full databases path;
• Accurate MySQL to Access date type conversion;
• Improved the work of engine with MS Access databases.
• Added support of AutoIncrement (AutoNumber) fields conversion;
• Added support of field default values conversion;
• Feature to configure application work using command line parameters;
• Corrected serious bug that caused problems while parsing of SQL expressions on some servers;
• Redesigned help file.
• Option to select a certain number of tables from source database to be processed (copied/converted)
• According to the restrictions of the destination database, the dialog is shown up for you to edit all incorrect table names. By default, each wrong symbol is replaced with '_' symbol.
• There is a possibility to replace/remove some symbol/symbols in names of tables and fields (which are required not to be used as they are reserved symbols for MySQL internal purposes) with a substitute symbol.

Database synchronization:

This feature is very useful when updating a database from another one or adding data from several source DBs to only one destination DB (special emphasis is laid on MS Access to MS Access synchronization).

Features of database synchronization:

• Option whether to copy or not the identical records to the destinition database
• Accurate external links handling when synchrinizing from MS Access to MS Access

• Windows 95 or later or Windows NT 3.51 or later
• At least 32 MB of available memory
• Necessary privileges to write into database on the target MySQL server

• Does not convert system (hidden) tables.
• Does not convert relationships between tables.