Kulrom thx for ur help~ i already fix the problem by using below code:
ALTER TABLE tblName ALTER COLUMN fieldName IDENTITY IDENTITY(999,1)
it can work nicely but i have to make sure the number i set to start is the bigger number in the table.
i do this is because i develop a system which can sync database between PC (use .sdf) and PDA (use .mdb). Both also have their own Primary Key (for PDA i start from 0, PC i start from 268435455). So when sync i know which data is create by which machine. Because of my system allow user to do restore, the AutoNumber may duplicate. So if user restore the database either PC and PDA, when sync, user will ask to select which database he/she want to refer. If choose PDA then PC database will delete and PDA will pass all the data to PC (by using TCP/IP). If system cannot found the database it will create new database and run the script i already set, so the Key is start from 268435455. Sound like no problem, but my system have 1 level link. Each data will carry the link key (which is Autonumber for the selected data). So the only way i found out is change my Autonumber to int first, so all the data from PDA will send to PC, after complete sync i change back the int to Autonumber.
Is hard to explain to u, bad explaination + poor english
. Anywhere hope you can know what i want to tell u.
If you know what is my problem and have best way to soft my problem pls tell me
. The hard thing how to let my database working without any error, because of my database using AutoNumber, system allow to restore, database need to sync, first level link.