• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Gaps in AutoNumber Field Values

Q1:When I accidentally add a new record to a table with an AutoNumber field and then delete it, the next record I add has the wrong AutoNumber value—increment of 2 instead of 1.
That's the major drawback of AutoNumber fields, especially when the AutoNumber field value corresponds to a physical record, such as an invoice or check number. The AutoNumber feature offers no simple method of replacing an incorrect record that you delete from the table. The best approach, which insures that your table is auditable, is to never delete a record from a table with an AutoNumber field. Instead, type VOID in an appropriate field, and add an explanation (if there's a field available to do so).

Extra Indexes Added by Access

Q1:After you specify a primary key on a field containing the characters "ID", an additional index appears for the field.
In many cases, Access automatically specifies a primary key and index on fields whose names contain the characters "ID", "key", "code", and "num" when you create or import tables. This behavior is controlled by the contents of the AutoIndex on Import/Create text box of the Tables/Queries page of the Options dialog. When you change the primary key field(s), the old index remains. You can safely delete the automatically added index.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint