This Help File Page was last Modified on 06/12/2016
❑Validating the Micro Key Millennium Series™ Database Structures on a routine basis is important:
•This process will analyze the database for corruption and report the table(s) affected by it.
•Validating your database on a regular basis is very important.
•Any reported problems can then be reported to Technical Support for diagnosis, resolution and/or correction.
•It is recommended that you run this process on a machine that is not the Primary server and not the machine running the Live SQL database.
•It can be run on any workstation (or any of the backup servers).
❑To Validate the Database Structure(s):
•To access the Validate Database utility:
a)From the Backstage Menu System Select the Maintenance Menu then Select the System Administrator sub-menu, or
b)From the Quick Access Menu, Select the Maintenance Menu then Select theSystem Administrator sub-menu
✓Then, Choose the Validate Database option
Validate Database dialog
✓Also validate the MKMS database - Check this box to include MKMS.db in this validation process (recommended).
✓Start - To start the validation of the MKMSDefault.db database (and MKMS.db, if this is also selected), Click the Start button.
The Validate Database progress list
✓The process continues until completion.
•Close - Click the Close box to return to the Main Menu.
✓If any Database Structure error message(s) relating to any table appears:
▪Perform a "screen shot" of the error message and print it.
▪Report these to Technical Support for diagnosis, resolution and/or correction.