Clearing Test Data

A

anna

I'm in the middle of setting up a database but as I've been working I've
put in a bit of test data to make sure code and queries are working.

Is there a way I can delete all this and reset the Autonumber fields
back to 1. This data is not 'real' so I would rather it didn't remain.
 
T

The Sisko

Delete the records by simply opening up the table, selecting all records
(CTRL-A) and hitting delete.

Compacting the DB will reset the auto number to 1 but as the autonumber
is normally just used as an internal primary key why bother ?

As other posters have said the autonumber field should not really be
used for generating sequential numbers as it cannot be relied upon not
to leave gaps. Sequential numbers should be generated from a number
field which YOU control the value of.

PaulC.
 
A

anna

Thanks.

No the numbers don't have to be sequential they are just there as
unique primary keys in a table. I just want to "clean up" a bit before
putting real data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Clearing Fields in a Word Form 5
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Replacing a Table with a Table from another database - reference issues 1
Clear Database And Reset the AutoNumber 4

Top