Jet 4 SQL DDL allows you to use the syntax:<BR><BR>column_name AUTOINCREMENT (seed,increment)<BR>i.e.<BR>Id AUTOINCREMENT (1000,1)<BR><BR>Or create a identical table, without specifying AutoNumber, just Long, put 999 in the field and then do an append query to the real table and then delete the record.
but where to give id autoincrement(1000,1). Is it after declaring recordset or before that. Is it when we r adding a new record to the table or at the beginning of programme. I tried it using the recordset, but the error comes as variable autoincrement is not declared.please send me the details