Auto Number

[bladeuk]

Hi,

can anyone advise?

I have a database (Access 2003) which has an input table that gives an auto number to each new entry created.

For some reason, after record 3449 the auto number has decided to populate itself to 164237057 and subsequent records are now following from that number. e.g. 164237058, 164237059 and so on.

I have other databases I have built that have far more records in than this but this has not happenned before.

Can anyone shed any light?

Appreciated

 

[bladeuk]

Denis,

Finally had chance to look at this.

Didn't need all the article but the relevant bits did the trick.

Many thanks again.

Dave

 

[SydneyGeek]

Dave, glad it's sorted.

Denis