Split a table into related tables (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

  1. On the Tools menu, point to Analyze, and then click Table.
  2. Follow the instructions in the steps of the Table Analyzer Wizard.

For more information on the Table Analyzer wizard, see the Knowledge Base article How the Table Analyzer Wizard Works, at http://support.microsoft.com/default.aspx?scid=kb;en-us;292799.

 Note   In a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.), the tables reside in a Microsoft SQL Server database; therefore, the Table Analyzer is not available.

Applies to:
Access 2003