autonumber problem

[nadesico]

I am trying to import a table from another access database, and when I do the
autonumber jumps and is 10400 higher than the previous autonumber. Also
tried to manually import the table and it still does this. Does anyone know
why this is happening and if so how to fix it. Any help would be appreciated.

Thanks

 

[Klatuu]

It should not matter what the autonumber value is. Autonumber fields should
not have any meaning to your application. Autonumbers should only be used
for Primary keys and in table relationships.

 

[Jeff Boyce]

I'm with Dave -- Access Autonumbers are largely unfit for human consumption.

If you'll describe WHAT you are using autonumbers to do, the newsgroup
readers may be able to offer other ways to get that done.

Regards

Jeff Boyce
Microsoft Office/Access MVP