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 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 |
Have questions? Contact us