Re: AutoNumber Question

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 07:01:10 -0800

Brigitte

To the best of my knowledge, NONE of the versions compact automatically
(although you can check a checkbox in Tools|Options to make this happen in
'02) ... and any time you do a Compact/Repair, you risk losing your db
unless you've backed up first.

Autonumbers in Access are intended as unique row identifiers, so there's
rarely a need to show them to users or try to make sense of them. And if
you've set up related tables, using the primary key (autonumber) from table1
as a foreign key in table2, "re-assigning" autonumbers in table1 will hose
your table2 relationship!

Good luck

Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: FAQ? factors influencing choice of data type for primary key
    ... In the past, I tended to use AutoNumbers in all tables, for consistency. ... For example, in a current project, a table 'tblAccident' is ... FROM tblAccidentStatus INNER JOIN (tblAccidentLevel INNER JOIN ... The primary key of tblAccident itself is still an AutoNumber, however, as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: null but not null
    ... I agree with you on the use of autonumbers. ... they prefer to use meaningful Unique data. ... primary key. ... we are properly normalized and the [SuperVisor] field is an FK to ...
    (microsoft.public.access.forms)
  • RE: Autonumbering Primary Keys
    ... Try a groups search for "increment number ... primary key" or "increment autonumber" or "simulated autonumber" or something ... > Access suggests that I have a separate column for OrderID using Autonumbers. ...
    (microsoft.public.access.gettingstarted)
  • Re: automatic consecutive numbering
    ... Keep in mind that the Primary Key can consist of more than ... >I will go to your website and study your example. ... >> Autonumbers should never be used for anything other ... >> assigned to equipment located in my facility. ...
    (microsoft.public.access.gettingstarted)
Loading