The documentation tool that comes with Access 2000 (under Tools, Analyze, Documentor) is VERY slow compared to the Access 97 version. I do not understand why. I use this feature frequently to print out the field names of a table. It is so slow in MS Access 2000 that I designed my own. Here is its story!

Do you have a design that assigns custom order numbers or some other text+number type field, and they do not sort properly? Perhaps the article, My Order Numbers Do Not Sort will explain the problem, and a solution.

If you have used Access 97's documentation feature (under the Tools / Analyze menu) and then subsequently used the one that came with the new Access 2000, you probably noticed a substantial decrease in speed. It was bad. Here is my method of getting a Faster Documentation Tool in MS Access.

Database design theory includes data design standards called normal forms. The process of making your data and tables match these standards is called normalizing data, or normalization. By normalizing your data, you eliminate redundant info and organize your tables to make it easier to maintain the data and table structures. See more in our article, Normalizing Data.

Discussion of Null

Discussion of the msysObjects Hidden Table

Discussion of Primary Keys

Discussion of Data Recovery Issues

Filtering Table Data

 
Note: This web site dedicated to MS Access database users is an independent publication of Richard W. Killey and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft® Corporation.
 

© 2006, 2007 Richard W. Killey. All Rights Reserved.