AutoNumber Random Number not Random

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brian (anonymous_at_discussions.microsoft.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 12:14:46 -0800

I have a table structure that uses "Autonumber" for the
data type (primary key) with the field size and new value
settings as "Long Integer" and "Random." The table is
populated by multiple users while not connected to a LAN,
then periodically synchronized. However, during a test
of the application we found two of eight records with the
same primary key number. After a little trial and error
I found the following number sequence produced by the
random number generator for six sequentially entered
records:
   1080228088
   1080247740
   1080258193
   1080261960
   1080262122
   1080293097
The pattern does not look random.
Any thoughts on why Access is not producing random
numbers for this field? How do I fix this problem?

Relevant Pages

  • Re: filling in primekeys through forms
    ... > In table design view there is a data type column. ... there is an autonumber feature that is ... relationship between this table and other tables in the database." ... PRIMARY KEY? ...
    (microsoft.public.access.forms)
  • RE: Using 2 Autonumbers in 1 table
    ... the registration it belongs to and the other the primary key of the course it ... Key with a data type of Autonumber. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Primary Key
    ... In your main table, the data type should be ... AutoNumber. ... "John" wrote in message ... > the 5 tables...can I put the primary key of the central ...
    (microsoft.public.access.tablesdbdesign)
  • Re: FAQ? factors influencing choice of data type for primary key
    ... >are important in choosing the data type for a primary ... >example, an Autonumber as a primary key, are there ... >could use the category name itself as a primary key - ... >it is a foreign key? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: filling in primekeys through forms
    ... Autonumber is a property, not a data ... A data type is also required, usually INTEGER but could be other ... alphabetically, a better choice of primary key would be (LastName, ... FirstName, NameID) in that order. ...
    (microsoft.public.access.forms)