Troubleshooting

graphics/troubleshooting.gif

Gaps In Autonumber Field Values

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

After 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.



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net