[AccessD] Autonumbers - Change ID from Number to AutoNumber

Thanks Doug I will get on that tomorrow.

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, March 24, 2010 11:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Autonumbers - Change ID from Number to AutoNumber

Build a new empty table with the autonumber field instead of your old id
field.
Use an append query to add all the records from your old table, appending
the old id field to the new autonumber field.
Replace the old table with the new.

Doug

On Wed, Mar 24, 2010 at 4:21 PM, Max Wanadoo <max.wanadoo at gmail.com> wrote:

> Hi Guys,
>
> I have a table with a unique indexed ID with random numbers throughout.
> Many  blanks in the sequences.
>
> Some of these IDs are related / cross-referenced to other tables.
>
> Is there  anyway  I can change this ID to an  Autonumber so that 
> future records get an autoincremented ID?
>
> I  do not want to change the numbers in there  if possible.
>
> Thanks
>
> Max
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com