Microsoft KB Archive/94597

= ACC: System Objects Retain System Object Properties =

Article ID: 94597

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q94597



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



SUMMARY
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 table.



MORE INFORMATION
Operations, such as Import, Rename, Copy, and Paste, do not change the flags in MSysObjects table. 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 to 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 to 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.

