Simply put, there will always be a disadvantage when using an application for a purpose that it wasn’t created for so what are the snag in using MS Access offline?.
An SMB using the offline version of MS Access in an environment that requires an online database is no exception. The problems they will encounter, sooner or later, include:
- Syncing issues: as we’ve mentioned above, data that is stored on multiple, offline devices will take time before it is merged and synced on the main, central MS Access database which causes delays and errors. The records’ inaccessibility to more than one user at a time is a major cause of such errors (despite a fix that is available, i.e.).
- Limited storage: as of going to post, MS Access only has a maximum total storage capacity of just 2GB – a ridiculously tiny amount of storage space by even the “tiny” SMBs’ data requirement standards of today.
- Fewer users: again, at the publishing of this post and in theory, MS Access allows about 255 people to concurrently connect to the database. In reality, though, that number is much lesser without having to resort to some complex configurations and adding an SQL Server as a back-end storage system. At the end of the day, it still won’t be the best candidate for a truly collaborative online working environment.
- Added costs, responsibilities: whether it is the cost of the server it is running on or the salary of the administrator who is going to take care of it, a database always comes with a bill that the SMB owner has to foot – payment being in the form of time, money or energy.
- License fees: also, Microsoft has a no-nonsense policy when it comes to its products’ licenses and usage rights – any business that would try to circumvent their policy will, sooner or later, pay the price. The best way to avoid a lawsuit? Opt for database software solutions that are as secure and reliable (If not more so) but cost a mere fraction of the price.
Now, this list could have been longer, but the points included in it should be enough to paint a clear picture: an offline database with limited features, unnecessary overhead costs, and the inability to be accessed over the Internet does not provide an upwardly-mobile SMB with a viable data storage solution.