Show All

Save a database object

1. Click Save on the Design toolbar.
2. Do one of the following:
   • If you are saving a database object for the first time, type a unique name in the Save As dialog box, and then click OK. If you click Cancel in the Save As dialog box, the object is not saved.
   • If you are saving a data access page for the first time, specify a location and name for the HTML file in the Save As Data Access Page dialog box.

     To save the page so that you can use it over a network, select a network location in the Save in box, or specify a UNC path in the File name box. If you save the page to location that specifies an absolute path (a path that contains a drive letter), Microsoft Access displays a message stating that the page might not be able to connect to data through the network. To connect through a network, edit the connection string to specify a network (UNC) path.

Notes

• You don't need to save new data in records. Access automatically saves a record when you do any of the following: move the focus to a different record; close the active form, datasheet, data access page, or database; or quit Access.
• Access automatically saves changes to your data whenever you quit. However, if you have made changes to the design of any database objects since you last saved them, Access asks whether you want to save these changes before quitting.
• If you make a change in PivotTable view, Access updates the PivotChart view automatically. Similarly, if you make a change in PivotChart view, Access automatically update the PivotTable view. When you save the object, you also save the PivotTable and PivotChart views.