MS Access works only on Windows whereas MySQL works on almost all platforms. MS Access does not support Partitioning feature whereas MySQL has composite, Range partitioning support. ... MS Access database is more suitable for desktop use with a small number of users accessing it simultaneously.