|
|
|
|
Make A Copy Before Your Update! Before you run a new update query (or make substantial changes in some other way to a table), make a copy of it--just in case. It only takes a minute, compared with the hours and days it can take to reconstruct a table for which you have no reliable backup. In Access 97, just open your database, select the Tables tab in the database window, and select the table that you want to copy. Then go to File | Save As/Export. At this point, Access 97 will ask whether you want to save the table to an external database or within the current database. Choose the latter option. When you do, Access will suggest a default name of "Copy of [Table Name]." In Access 2000, click File | Save As. The resulting dialog box will suggest the same default name and will offer you the option to save it as a table, form, or report. That naming scheme is fine, as long as you like having all your backup files grouped together in the "Copy of" section. On the other hand, you may want to keep your original files and the copies together when you're viewing your tables in List or Details view. To do so, just change the name of the target (copied) table to "[Table Name] Copy."
|
|