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 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
Full-text
Hash
Spatial
Partitioning N/A Hash
List
Range
Composite (Range + Hash)
Specific Data Types MONEY ENUM, SET
Forms Built-in N/A
Programming Language Visual Basic PHP