[AccessD] Autonumbers - Change ID from Number to AutoNumber

Oh, and I guess you will need to delete then recreate any relationships when
you replace the old table with the new

Doug

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

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>