ACC2000: AutoNumber and Identity Fields Do Not Contain "(AutoNumber)" When Adding New Records to a Page (225905)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225905
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you move to a new record on a data access page, (AutoNumber) does not automatically appear in AutoNumber and Identity fields.

MORE INFORMATION

Microsoft Access automatically puts a number into this field when you save the record. You cannot select this field and type a number that could affect the integrity of your data.

Steps to Reproduce Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click Page Wizard. Click OK.
  4. In the Tables/Queries list, click Categories. Move CategoryID and CategoryName from the Available Fields list to the Selected Fields list. Click Finish.
  5. On the View menu, click Page View.
  6. Click the new record button on the record navigation control.

    Note that CategoryID does not contain (AutoNumber).
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbDAP kbprb KB225905
©2004 Microsoft Corporation. All rights reserved.