What are the main advantages and disadvantages of utilizing Microsoft Access?

Answer 1

Access provides significant cost savings compared to most other database platforms due to the robust features that are included in the core application. A well built Access application does it all: multi-user platform, data storage, user interface (quick and easy form design), solid report capabilities, integration with Excel/Outlook.

However, Access is not a good solution when the number of users exceeds 15 to 20 concurrent users. Complex Access databases do not typically perform well over VPN's unless there is direct remote access to the server, and security features are not as robust as one would find with what are commonly called the "big boy" databases such as SQL Server and Oracle. Those "big boys" don't include interface design tools: they require separate programming for the user interface.

Answer 2

Advantage - it is fast and easy to build something that works, which makes it ideal for proof of concept development.

Disadvantage - it is structured as a single user system, so it isn't good as an actual development platform.