Cleanup and the CLEANUp Command - *12​.1​.SP3*

The command CLEANUp cleans up unwanted references in the database. It is possible to remove null references and unresolved/invalid references.

The logical attributes NULLREf, INVREF and UNRESOlved is used to sort out whether a reference attribute points to something valid or not. The syntax is the same for all three:

Q NULLRE (ATTNAME att )

Answers the question is the attribute att null (=0/0)?

Q UNRESO (ATTNAME att )

Is the attribute att pointing to an element whose existence we cannot find and verify? It could be that the database is missing or that the reference is truly invalid.

Q INVREF (ATTNAME att )

Is the attribute pointing to an element that is non-existent? This differs from unresolved in that the database that should accommodate the missing element is present in the active mdb.

For More Information

Refer to Reference Manual Database and Data Management /Database Navigation and Query Syntax / Cleanup and the CLEANUp Command.