Microsoft KB Archive/225869

= ACC2000: Monolithic Save Dialog Box Doesn't Qualify Object Type Being Saved =

Article ID: 225869

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225869





This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you save several objects at the same time (monolithic save), you may see the same name listed more than once in the Save dialog box.



CAUSE
You have given two different objects the same name; for example, you have a form and a report named Employees.



RESOLUTION
Microsoft Access 2000 allows you to give different objects the same name, but the objects will appear identical in the monolithic Save dialog box. To avoid this behavior, be sure to name your objects in a manner that distinguishes them.

One naming convention that you can use to distinguish different objects is to use a different prefix for each object, for example:

tbl = table

qry = query

frm = form

mcr = macro

rpt = report

dap = data access page

mod = module

In this manner, you can name a form as frmEmployees and a report as rptEmployees, and be able to determine which name represents which object.



Steps to Reproduce Behavior
 Open either the Northwind.mdb or NorthwindCS.adp sample database. In the Database window, click Reports under Objects, and then click New. In the New Report dialog box, click AutoReport: Columnar, click Employees in the Choose the table or query where the object's data comes from box, and click OK. On the File menu, click Save, and save the report with the name Employees. On the View menu, click Design View.</li> In the report header, click and drag the Employees label to the right edge of the header section.</li> Press F11 and click Forms in the Database window.</li> Open the Employees form in Design view.</li> In the form header, click and drag the EmployeeName text box to the left edge of the header section.</li> Press F11 and click Modules in the Database window.</li> Open the Startup module in Design view.</li> Place the pointer on the end of the Option Explicit line.</li> Press the spacebar once and type Startup .</li> Press ALT+TAB to get back to Microsoft Access.</li>  Close the database by clicking the Close box (X) in the top-right corner of the Database window.

Note that the Save dialog box appears: <pre class="fixed_text">   Save changes to the following objects? Employees Employees Startup Note how you can't determine which Employees represents the form and which the report. Click No To All to abandon the changes. </li></ol>

<div class="references_section">