This is the Access2MySQL Sync manual. You will find here anything you need to know about this tool.

     Access2MySQL Sync is an effective application which allows to easily convert and synchronize .mdb (Microsoft Access) databases to MySQL and vice versa, unlike other similar tools, which commonly perform only one-way conversion and synchronization. Access2MySQL Sync performs Unicode support as well as a large number of useful features. 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. We doubt that you will have any problems with it, but in any case FAQ page is available for your convenience. Regularly benchmark tests show that Access2mySQL products obviously stand out from the crowd of similar data conversion tools with its improved general functionality, high speed of syncronization and stability of the software. You are welcome to read our Access2MySQL White Paper to get more information about the advantages of our programs.

What's new:

• 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
• Foreign key (relations) support.
• Insert-synchronization and Update-synchronization available
• Advanced customization options:
  - partial selection for database objects to be converted.
  - database objects (tables, fields, indexes) renaming before conversion.
  - detection of possible conversion errors at customization stage.
• Sessions support - all your settings can be saved and restored then.
• `ENUM` and `SET` MySQL database types support.
• `GUID` Access database type support.
• `OLE Object` packages support.
• Skins support.
• Multilanguage Support
• Problem with MSAccess to MSAccess conversion fixed
• On MS Access connection page "Database" field now "readonly" to prevent wrong DB name entering

Features:

• Interactive (GUI) mode / command line mode;
• Support for MS Access Work Groups;
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL internal purposes) with a substitute symbol.
• Automation of the conversion process with built-in scheduler
• Ability to select ISAM, MYISAM, HEAP, InnoDB  or BDB table types when copying data to MySQL.
• High speed of data conversion. Access2MySQL Sync speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server not through ODBC like other similar converters. 

Requirements:

• Windows XP/2000/NT (NT only with Internet Explorer 4.01)
  
• At least 32 MB of RAM
  
• Necessary privileges to write into database on the target MySQL server.

Important notices:

• Does not convert system (hidden) tables.
• Does not convert linked tables.

Application stages

• Start - how to start.
• Process stages - stages of conversion process.
• Registration - how to register.
• FAQ - if you still have questions, which were not highlighted in the previous sections, or experience troubles in using the application, please, check the Access2MySQL Sync FAQ page out.