[AccessD] Autonumber To Start From 900120

Hi Paul,

see this;
http://www.mvps.org/access/tables/tbl0005.htm

basically you need to do an append query into your table with a record one 
number lower than you wish your autonumber first value to be. Then delete 
that record.

Gary Kjos
garykjos at hotmail.com





>From: paul.hartland at fsmail.net
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd <accessd at databaseadvisors.com>
>Subject: [AccessD] Autonumber To Start From 900120
>Date: Thu,  6 May 2004 14:24:45 +0200 (CEST)
>
>To all,
>Is there a way of telling the Autonumber where to start from in a Database 
>?
>Thanks in advance.
>Paul
>
>--
>
>Whatever you Wanadoo:
>http://www.wanadoo.co.uk/time/
>
>This email has been checked for most known viruses - find out more at: 
>http://www.wanadoo.co.uk/help/id/7098.htm
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com