Is there a way inside access to wipe all data from tables?
I mean properly so all my primary keys (Autonumbers)
start from 0 again..
Cheers
Printable View
Is there a way inside access to wipe all data from tables?
I mean properly so all my primary keys (Autonumbers)
start from 0 again..
Cheers
Delete the rows, and then compact the database. That'll do it.
First truncate all tables (of you have ralationsship use delete ) then compress/ fix the DB and alle the autonumbers will start at 0
Second possibility, make a script for all you tables, drop then and recreate them
Cheers lads, I'll give it a whack!
That's worked great, cheers again!