Problems with autoassigning ID #s

B

BSCHUETTER

I use Access 2002 (having just updated from a very early version of Access).
I use it to maintain a database of sheet music, using the sequential Auto
assigned ID number on the music itself. My last # is 940. After I opened the
old file in 2002, Access won't assign the next number to the next record I
enter (piece of music) , instead assigning a large 6-digit number. I don't
know what to do and now can't use database any more for new music entries.

Please help!
 
A

Alex White

Hi,

Sounds like the field for auto numbering has gone larger than you
require, other than copying the renaming the table to something else and
then creating the table again then copying the data, the only thing I
can think of is don't use the auto numbering and make your own by
incrementing the largest number already in the specified table.

If you want to know how to do auto numbering via code post back here

Regards

Alex White MCSE MCDBA
www.IntraLAN.co.uk


-----Original Message-----
From: BSCHUETTER [mailto:[email protected]]
Posted At: 24 April 2005 19:15
Posted To: microsoft.public.access.gettingstarted
Conversation: Problems with autoassigning ID #s
Subject: Problems with autoassigning ID #s

I use Access 2002 (having just updated from a very early version of
Access).
I use it to maintain a database of sheet music, using the sequential
Auto
assigned ID number on the music itself. My last # is 940. After I opened
the
old file in 2002, Access won't assign the next number to the next record
I
enter (piece of music) , instead assigning a large 6-digit number. I
don't
know what to do and now can't use database any more for new music
entries.

Please help!
 
Top