From:       To:      
Home > Documentation > MS Access to MySQL

Microsoft Access vs MySQL

This table covers the most differences between MS Access and MySQL. It can help you to understand possible challenges in MS Access to MySQL migration. Pay attention to red marks.

  Microsoft Access MySQL
Max DB size 1 GB Unlimited
Max Table Size 1 GB MyISAM storage limits: 256TB;
Innodb storage limits: 64TB
Max Row Size 16 MB 64 KB without BLOB and TEXT columns
Indexes Basic tree Basic tree
Partitioning N/A Hash
Composite (Range + Hash)
Specific Data Types MONEY ENUM, SET
Forms Built-in N/A
Programming Language Visual Basic PHP

Have questions? Contact us