MKS Help

Validate Database

This Help File Page was last Modified on 06/12/2016

Hide Navigation Pane

Validate Database

This Help File Page was last Modified on 06/12/2016

Previous topic Next topic No directory for this topic No expanding text in this topic  

Validate Database

This Help File Page was last Modified on 06/12/2016

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

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

 

HelpFilesValidateDatabase

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.

 

HelpFilesValidateDatabaseInProgress

 The Validate Database progress list

 

The process continues until completion.

 

Close - Click the Close HelpFilesCloseBoxbox 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.