0414 228 974 [email protected]

Why Choose
Microsoft Access?

Is Microsoft Access the right solution for your project?

Why Choose
Microsoft
Access?

Is Microsoft Access the right solution for your project?

LIMITATIONS

Microsoft Access may not be your best choice if:

  • You need to capture real time or time critical transactions – e.g. from a lab instrument.
  • Any single table in your database could have more than 1 million large to medium-width records, or 5 million small-width records (i.e. 3-4 digit numeric or short text fields).
  • You would regularly have more than 15 to 20 people actively using the database at the same time. (Use SQL Server with an Access front-end.)
  • Your servers experience periodic, unexpected crashes – e.g. more than 1 per month. (In this case you’ll have problems with any database system.)
  • You require extensive database security because of the highly sensitive nature of the data. (Use SQL Server with an Access front-end.)