Gaps In Autonumber Field ValuesWhen 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 AccessAfter I specified a primary key on a field containing the characters "ID", an additional index appeared 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 (from the Tools menu). When you change the primary-key field(s), the old index remains. You can safely delete the automatically added index. |