Auto numbering

[Hasan]

I have a field of Autonumber in my table i would like to
start at 50000 so i use the method of appending a record
with the value that i want the auto number to start at.
it worked the 1st time and then i had to delete all the
records in that table and started again but now the field
doesn't start with the value i append but rather with the
last record that was appended which i deleted.
Any way to reset the memory in access or something coz it
doesn't recognize the new value appended and starts from
where the counter for auto number left off last time.
Thanks

 

[tina]

try compacting the database.
btw, it's not a good idea to use Autonumber for any field that will be seen
by and have meaning to the user, or if you need to maintain an unbroken
sequence of number assignment - because you can only control the initial
start value, after that you have no control.

hth

 

[Hasan]

Wat do u mean by compacting the database?

-----Original Message-----
try compacting the database.
btw, it's not a good idea to use Autonumber for any field that will be seen
by and have meaning to the user, or if you need to maintain an unbroken
sequence of number assignment - because you can only control the initial
start value, after that you have no control.

hth





.

 

[tina]

if you search the Access Help file for "compact database" (or search Google,
for that matter), you can read all about it.