Database corruption message when starting AYS
When starting AYS software I see a message similar to the following:
Why does this happen, and what should I do?
Microsoft Access database
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.
There are too many records to support rollback protection
When manually importing data from any import module into a Microsoft Access database, the following message appears:
There are too many records to support rollback protection.
Please disable rollback protection and try importing again.
Cause
When manually importing records into an AYS database, clicking the Test button imports all of the data but keeps track of all changes made so that those changes can be undone or rolled back at the end of the test. Warnings or errors that are logged during this test may be used to clean up the data set being imported before any live data in the target database is affected. Clicking the Import button still keeps track of all changes made so that if there is a critical error during the import then any changes can still be undone or rolled back.
When importing data into Microsoft Access databases, there is a limit as to how much data can be recorded in the list of changes. The above error indicates that the limit has been reached and a decision must be made to either undo the changes now, or continue without the ability to undo any changes.
Resolution
Option 1: If you are satisfied that the import data set is good then within the import module select the Options tab, and check the box next to Disable Rollback Protection. Once this option is checked then the Test button will no longer be available. Click the Import button to proceed with the import.
Option 2: If you are not satisfied that the import data set is good then break the data set into smaller chunks and test importing each chunk of data individually. Once you are satisfied that the import data set is good then you may either import each chunk of data individually, or import the entire data set. Follow the steps in Option 1 above to disable rollback protection before importing.