ACC: System Objects Retain System Object Properties (94597)

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.