ACC: System Objects Retain System Object Properties

 Last reviewed: August 13, 1997
Article ID: Q94597
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

A system object always retains the original system object attributes. Operations performed on system objects, such as Import, Rename, and Copy, preserve the flags in MSysObjects.

MORE INFORMATION

Operations, such as Import, Rename, Copy, and Paste, do not change the flags in MSysObjects. In order to get a copy of a system table without retaining the system settings, use a make-table query.

Steps to Reproduce Behavior in Microsoft Access 97 and 7.0:

  1. On the Tools menu, click Options. On the View tab, click to select the System Objects box, and then click OK.

  2. Import the MSysObjects table from the System.mdw.

  3. Rename the imported table TableNew.

  4. On the Tools menu, click Options. On the View tab, click to clear the System Objects box.

Note that the TableNew table disappears from the Database window because it has the attributes of a system object.

Steps to Reproduce Behavior in Microsoft Access version 1.x and 2.0:

  1. On the View menu, click Options. Set the argument for Show System Objects to Yes.

  2. In Microsoft Access version 2.0, import the MSysToolbars table from the SYSTEM.MDA. In Microsoft Access version 1.x, import the MSysAccounts table from the SYSTEM.MDA.

  3. Rename the imported table TableNew.

  4. On the View menu, click Options. Set the argument for Show System Objects to No.

Note that the TableNew table disappears from the Database window because it has the attributes of a system object.

REFERENCES

For more information about system objects, search the Help Index for "system objects," or ask the Microsoft Access 97 Office Assistant. 

Keywords          : TblFldp kbusage
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 13, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.