Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

After performing a routine Database Manager Build process, I received a warning that says “One or more database files have lost records…”. What is the problem?

April 26, 2017build database files manager Performing process received routine warning

0

Posted

After performing a routine Database Manager Build process, I received a warning that says “One or more database files have lost records…”. What is the problem?

1 Answer

0

Posted

A.07 The build process in Database Manager is intended to re-synchronize the keyed order of files only. In layman terms, it re-sorts your database in alphabetical or numerical order. However, it is not expecting to find database corruption issues during the building process. When it does, it sometimes gives up and inadvertently truncates a portion of your database. The error message is designed to warn you that a Database Manager Build process started with xxx records and ended up with yyy records. A column appears on-screen displaying the files that received the errors and the number of records lost. If the amount of records is minimal and on related to files of little importance, then do not worry about the message. However, if it has occurred on critical files like your customers or invoices, then you may need to consider restoring ManageMore from your last backup.