Autnumber error

[Edwik]

Hi all.

I have database in Access. In one table I have 2000 record with autonumbers (ID) from 1 to 2000. My Database was broken and after repairing my autonumber go from 7669500:
1999
2000
7669500
7669501
7669502
...........

Database work normally, bu I cant upsize it to MSSQL. Maybe this is the reason. Must I leave thi sequention or must i do something?

Thank You in advence.
Edwik

 

[RuralGuy]

Hi Edwik,

It really should not be a problem since the number should never be seen by a user but if it really bothers you then maybe Allen Browne can help.

 

[namliam]

This "broken" autonumer should not be the cause for you not beeing able to go to SQL server....

Good luck on your search

Season greetings from Amsterdam

The Mailman