Getting AUTONUMBER to Reset!!

[Guest_imported]

I have a serious issue. I have my database linked by autonumbers and for testing purposes I went through a couple of thet ables seperately and just added some data, now everything is out of sink. I have tried deleting the autonumber field, saving it and readding it again but the autonumber always returns back to the original number!!! How do I get it start back at 1????? Thanks

 

[danvlas]

Delete all data in the table and compact the database.

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[mikey69]

There is an SQL command "Alter" which will do it, I believe, provided you have JET4.

ALTER TABLE tablename ALTER COLUMN columnname COUNTER (1,1) is the syntax, I believe.

Haven't tried it but the book says so.