AUtonumber does not reset after compacting anymore (1 Viewer)

[duckdodgers]

I have a database that imports testdata from ascii files (via VBA routines) that has an autonumber field as a unique ID number. When I was developing the database, I would delete the records, compact the database and the autonumbers would start back over at the beginning (or the next value in the sequence). Since then (about two weeks ago), the autonumbers will not reset when I delete the last record(s) from the tables. I am not sure what I would have done to cause this to happen. I'm thinking it may be an index thing (the database has several tables that relate back to this autonumber field).

I would appreciate any help anyone can provide.

Thanks

 

[pono1]

Pete,

I've seen this happen too -- though only in a test DB, so I haven't followed up on this link...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q287756

Regards,
Tim

 

[duckdodgers]

Thanks Tim. I did search through the knowledge base, but I couldn't find this article. At least I have an explanation as to why, but the fixes may not be feasable. I tried the ALTER route, but the relationships won't allow this to happen. I'll have to look into this more.
Thanks Again.

Pete