The information in this article applies to:
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
MORE INFORMATION
When you delete an object from the Database window, it is not physically
deleted from the database at that moment. Instead, it is renamed to a
temporary name (for example, ~TMPCLP1) and hidden, so that it disappears
from the Database window. The renaming operation occurs very quickly,
regardless of the object's size. The hidden object is physically deleted
from the database as soon as you take any action other than the Undo
Deletion action.
Speed of DeletionThe time it takes to delete an object depends on how large it is and how fast the computer is that you are using. Smaller objects are deleted faster than larger ones. If the database that contains the object to be deleted is on a network file server, the deletion will take longer.How long an object deletion will take cannot be accurately predicted because the speed of deleting the object is also affected by the nature of the data contained in it. (For example, with tables, number columns are deleted more quickly than Memo and OLE columns.) Internally, Microsoft Access does not provide a status callback for object deletion; therefore, a progress indicator in the status bar is not possible. Because there is no progress indicator, Microsoft Access does not yield to the system until the object deletion procedure is complete. Therefore, you cannot abort the operation or switch to another application while the object is being deleted. REFERENCESFor more information about the Undo option, search on the word "undo" using the Microsoft Access Help Index, or ask the Microsoft Access 97 Office Assistant. Additional query words: erasing
Keywords : kbusage GnlOthr |
Last Reviewed: March 11, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |