Many companies use MS Access databases for storing their business data. Actually Access databases works perfectly with small-sized databases and for limited number of users who have simultaneous access over network. But its usage is limited to 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 would be a good portable (non-server) alternative database system for replacement.
- Both Access and SQLite allow redistributing their engines with applications.
- 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 a better choice.
- Tighter integration with SQLite database engine offers better performance and application redistributing may be easier.
- The dynamic typing in SQLite allows it to do things that are not possible in traditional strong typed databases.
- SQLite as an open-source database engine has more liberal redistribution rights. Basically you can do with it whatever you want.