I'd suggest first adding an autonumber column, and a long integer number
column to the table. The autonumber will be filled automatically. Check
that it starts with 1 and increments by 1, and if so execute an update query,
updating the long integer number column to:
[YourAutonumberColumn]+1999999
You can then delete the autonumber column from the table and make the long
integer number column its primary key, or otherwise index it uniquely andset
its Required property to True (Yes). To increment the long integer number
column for subsequent new records Roger Carlson has simple methods for
generating custom 'autonumbers' in either a single or multi-user environment
at:
http://www.rogersaccesslibrary.com/forum/topic395.html
Or my slightly more complex method at:
http://community.netscape.com/n/pfx/forum.aspx?nav=libraryMessages&ts....
allows the next number to be generated to be reseeded at any time.
Ken Sheridan
Stafford, England
I have a table with data in it, whihc now needs to have a unique ID
added to each record. The ID must start at 2000000 and increment by 1
for each record.
Can I achieve this, and if so how?
