Printable View
I've got a table with a field defined as AutoNumber.
This field is the primary key for the table.
I have cleared out all the records, and want to reset the number to 1 before importing new records, but can't work out how to reset it. Can this actually be done, or do I have to define a new table ?
Delete all records( you did this) and compact the access db 3 times (dbwindow - menu - tools>Database>Compact or something).
Vince
Excellent ! Cheers Vince :) :)
Spent the last 10 minutes searching the site for similar problem, but couldn't find an answer that simple.
People were being told to recreate tables and move data over :eek:
Not quite sure why you suggested doing it 3 times though, I found once was enough ;)
Thanks again.
When you compact an access mdb - it flags those things to change on the first pass (changing counters and stuff.
On the second pass it removes those flagged things (including wasting space of records and reflags some more
On the third pass you've compacted as much as possible :)
But for your purpose - yup once'll be enough :)
Vince
Well you learn something new every day :)
Thanks for the info Vince ..... most helpful :D :cool:
Thank you Michelle ;)
Excellent bits of info.
Glad I read this thread.
:D :D :D :D :D :D :D :D :D