stop negative autonumber field

  • Thread starter Thread starter Shailesh Patel
  • Start date Start date
S

Shailesh Patel

Hi:
When I add record in Access 2002 db table, it inserts autonumber field
as negative value like -122600.
How to stop this?
Thank you for reply.

Shailesh
 
Using ADOX, you can reset the Seed property of the Column in the Table.
There is an example at:
http://allenbrowne.com/ser-40.html
that loops through all your tables and resets any that are using a negative
value.

To prevent the problem recurring, make sure you have JET 4 SP8.
It is available from the Downloads section of support.microsoft.com
 
Thank you so much, Allen!


Allen Browne said:
Using ADOX, you can reset the Seed property of the Column in the Table.
There is an example at:
http://allenbrowne.com/ser-40.html
that loops through all your tables and resets any that are using a negative
value.

To prevent the problem recurring, make sure you have JET 4 SP8.
It is available from the Downloads section of support.microsoft.com
Click to expand...
 
Back
Top