[AccessD] Initial value of an ANPK

Gary Kjos garykjos at gmail.com
Thu Dec 6 13:14:06 CST 2007


http://www.mvps.org/access/tables/tbl0005.htm

You have to append a record with a number one less than your first
real record. Then delete that dummy record after you have a real
record in there.

GK

On 12/6/07, Arthur Fuller <fuller.artful at gmail.com> wrote:
> I seem to recall that there's a way to specify the starting value for an
> AutoNumber PK but I can't remember how to do it. Anyone?
>
> TIA,
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list