Auto numbering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hasan - 25 Aug 2004 07:14 GMT

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

Reply to this Message

tina - 25 Aug 2004 07:52 GMT

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

> 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
[quoted text clipped - 7 lines]
> where the counter for auto number left off last time.
> Thanks

Reply to this Message

Hasan - 26 Aug 2004 00:52 GMT

Wat do u mean by compacting the database?

>-----Original Message-----
>try compacting the database.
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

tina - 26 Aug 2004 02:15 GMT

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

> Wat do u mean by compacting the database?
>
[quoted text clipped - 32 lines]
> >
> >.

Reply to this Message