|
 |
asp_databases thread: Adding an AutoNumber (Random) To Access97
Message #1 by "Ali" <alakale@y...> on Sun, 14 Jan 2001 00:25:04 -0000
|
|
Hi, i'd like to add a field to an ms-access97 database whose DataType is
AutoNumber and it has to be ***Random***. I got some help from others and
came up with :
objComm.CommandText = "ALTER TABLE table1 ADD COLUMN MyField COUNTER"
This only creates a new AutoNumber Filed but it's *NOT RANDOM*.
Please help me out. (using Microsoft.Jet.OLEDB.4.0)
Message #2 by "Dallas Martin" <dmartin@z...> on Sun, 14 Jan 2001 09:08:19 -0500
|
|
There is no such thing as a random auto-number field. It defeats the purpose
of auto-numbers.
----- Original Message -----
From: "Ali" <alakale@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, January 13, 2001 7:25 PM
Subject: [asp_databases] Adding an AutoNumber (Random) To Access97
> Hi, i'd like to add a field to an ms-access97 database whose DataType is
> AutoNumber and it has to be ***Random***. I got some help from others and
> came up with :
> objComm.CommandText = "ALTER TABLE table1 ADD COLUMN MyField COUNTER"
> This only creates a new AutoNumber Filed but it's *NOT RANDOM*.
> Please help me out. (using Microsoft.Jet.OLEDB.4.0)
>
Message #3 by "Wally Burfine" <oopconsultant@h...> on Mon, 15 Jan 2001 05:18:05 -0000
|
|
In access you can set the auto number field to generate random numbers. This
is used in replication
>From: "Dallas Martin" <dmartin@z...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: Adding an AutoNumber (Random) To Access97
>Date: Sun, 14 Jan 2001 09:08:19 -0500
>
>There is no such thing as a random auto-number field. It defeats the
>purpose
>of auto-numbers.
>
>----- Original Message -----
>From: "Ali" <alakale@y...>
>To: "ASP Databases" <asp_databases@p...>
>Sent: Saturday, January 13, 2001 7:25 PM
>Subject: [asp_databases] Adding an AutoNumber (Random) To Access97
>
>
> > Hi, i'd like to add a field to an ms-access97 database whose DataType is
> > AutoNumber and it has to be ***Random***. I got some help from others
>and
> > came up with :
> > objComm.CommandText = "ALTER TABLE table1 ADD COLUMN MyField COUNTER"
> > This only creates a new AutoNumber Filed but it's *NOT RANDOM*.
> > Please help me out. (using Microsoft.Jet.OLEDB.4.0)
> >
Message #4 by "Ali" <alakale@y...> on Sun, 14 Jan 2001 23:48:05 -0000
|
|
Well, you can create an autoNumber in Access and that can be set to be
random, so it generates auto-random numbers,
|
|
|
View Cart
