What users are saying about

Amazon Aurora

41 Ratings

Microsoft Access

497 Ratings

Amazon Aurora

41 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Microsoft Access

497 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.3 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

Microsoft Access

Microsoft Access is great for integrating with .NET for both stand-alone and web-based solutions. Since it is so widely-used, it is fairly easy to find people in your existing work pool who can use it, and also easier to find new applicants who can hit the ground running with this technology. It is terrific for small businesses or small departments within larger organizations who want to be in control of their own simple projects and prototyping. It is well-suited for environments where security is locked down but employees still need to accomplish simple programming tasks.
No photo available

Pros

  • Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
  • Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
  • Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
Vasco Mendes profile photo
  • Microsoft Access is great at cranking out quick solutions for simple programming problems
  • Once Access has been learned, the same concepts are readily transferable to create more complex VBA macros in Excel, Word, and other Microsoft Office products.
  • It is easy to integrate with most other Windows-based back-end databases such as SQL and Oracle.
  • It can be placed on websites to allow remote users to access the data
No photo available

Cons

  • The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
  • Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
  • Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Vasco Mendes profile photo
  • It cannot accommodate as many records or as many concurrent users an Oracle or similar database can.
  • It is not as reliable as a database of 'industrial strength' is.
  • It does not work fast, particularly when when large amount of code was used for its design or when a relatively many users attempt to utilize it simultaneously.
Fred Abraham, P.Eng profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access9.0
Based on 15 answers
I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.
Alyssa Moy, MBA, PMP profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft Access7.0
Based on 3 answers
It's easy to use, but for those who work with Excel or for people who have not used a database or something similar, it's not easy at all.
Jennifer Lamas profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 1 answer
I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.
No photo available

Support

No score
No answers yet
No answers on this topic
Microsoft Access7.5
Based on 2 answers
I intend to elaborate very soon via another update, after checking some of my notes.
Fred Abraham, P.Eng profile photo

Alternatives Considered

Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
Vasco Mendes profile photo
Microsoft Access is the only real database software that I've used in this aspect. Yet to be honest, I can't think of another competitor that would compare.
Ryan Husbands, MBA, CPA profile photo

Return on Investment

  • The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
  • The database replication and schedule for backup tasks are much easier, so less prone to errors.
  • We have never had a database downtime on our applications, which is essential for our customer business.
Vasco Mendes profile photo
  • The access databases work very well with many of the programs for Windows-based software development. You can also use your tables in products such as Microsoft SQL Server and in others not based on Microsoft such as Oracle and Sybase.
  • Easy to install and use: To create access databases, just install Microsoft Access and this is something that any database administrator can do in just a few minutes, leaving a fully functional relational database management system. Like many other Microsoft applications, Access contains wizards that guide you through every step of the way. The user interface is intuitive, speeding up data recovery.
  • It can be placed online: Although it still has limitations on the number of users with simultaneous connection, when there is a need for remote users, it can give full control and functionality to an access database so that teleworking can become a viable option for database administrators.
Thairy Ollarves profile photo

Pricing Details

Amazon Aurora

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Microsoft Access

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details