Many companies use MS Access databases for storing their business data.
Access databases are often a great fit with small-sized databases and
for limited number of users who have simultaneous access over a network. But
its usage is tightly limited to the Windows operating systems family.
SQLite would be a great option to extend your reach to many platforms beyond
Windows (iOS, OSX, Android, Linux, etc.). It is often used as a good, portable
alternative database system.
- SQLite is a free, compact, embeddable SQL database engine.
- As mentioned above, SQLite is cross-platform - so if your app needs to be distributed to many platforms then SQLite is the better choice.
- Both Access and SQLite allow for redistribution of their engines with applications.
- SQLite as an open-source database engine that has more liberal redistribution rights. Basically you can do with it whatever you want.
- Tighter integration with the SQLite database engine offers for better performance and often application redistribution is easier.
- Dynamic typing in SQLite allows it to do things that are not possible in traditional strong-typed databases.