What is the maximum number of records that can be entered?

While the physical databases are capable of storing millions of records, the practical maximum number of records that can be entered in the various database tables depends much on the type of database, the number of simultaneous users, and the physical server hardware.

Experience has shown that Microsoft Access databases with 5 to 10 users experience a gradual slowdown as more records are added with the practical limit being in the range of 50,000 to 100,000 records per table. Microsoft Access databases also have a physical file size limit of 2 Gigabytes.

SQL databases are much more robust and still perform responsively with millions of records.

Many program modules use a unique number to identify each record which will also limit the number of possible records. For example, repair orders use an eight-digit repair order number, therefore the maximum number of possible repair orders is 99,999,999.

When the program is run in demo mode (i.e. without a license), all tables are limited to 200 records.

What is the difference between Microsoft Access and SQL databases? (article coming soon)
How can I configure the program to run faster? (article coming soon)

AYS Versions: All
AYS Editions: All
Operating Systems: All
Databases: All