ACC: System Objects Retain System Object Properties

• 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 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.

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.

REFERENCES

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

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

Last Reviewed: March 13, 1999