j******t 发帖数: 11 | 1 or it is the way Access primary key goes? | m**********m 发帖数: 92 | 2 If you are using autonumber in Access or identity in MS SQL Server, then it
works this way. Nothing was wrong. The number is not reset when you delete
records. To reset the autonumber to a certain value, you need to use
DBCC CHECKIDENT to reseed the column at certain value
in sql server 7. Please google its usage and examples.
【在 j******t 的大作中提到】 : or it is the way Access primary key goes?
| j******t 发帖数: 11 | 3 thanks again! //BOW
just found out that one "stupid" way to solve the problem is to delete the key
and insert it to the table again. then everything works out well.:)
【在 m**********m 的大作中提到】 : If you are using autonumber in Access or identity in MS SQL Server, then it : works this way. Nothing was wrong. The number is not reset when you delete : records. To reset the autonumber to a certain value, you need to use : DBCC CHECKIDENT to reseed the column at certain value : in sql server 7. Please google its usage and examples.
|
|