Re: How do I empty a table?
- From: "BruceM" <bamoob_at_yawhodotcalm.not>
- Date: Fri, 15 May 2009 07:33:45 -0400
You could run a delete query:
DELETE * FROM YourTable
If you use cascading deletes when you set up the relationships you can run
the query on the main table in the relationship, and the related records
will be deleted also.
I have been known to open the tables, and select and delete all test data.
In this case I think it's OK for the developer to work directly with the
tables.
When you are done, run compact and repair (after backing up first). This
will reset the autonumber to 1 (I can't say for sure how this works in
Access 2007, though). In general, compact and repair is a good idea before
deploying the database.
"Steve Hayes" <hayesmstw@xxxxxxxxxxx> wrote in message
news:3deq059ki417i8vq0ked2o2d49s3jngfb3@xxxxxxxxxx
I want to develop a database and test it with test data.
How do I empty the database of the test data when I've finished testing
and
want to enter real data?
In Paradox it was easy and obvious, but in Access I haven't been able to
find
it.
--
Steve Hayes from Tshwane, South Africa
Web: http://hayesfam.bravehost.com/stevesig.htm
Blog: http://methodius.blogspot.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop
uk
.
- Prev by Date: Re: How do I empty a table?
- Next by Date: Re: Descriptions for Table
- Previous by thread: Re: How do I empty a table?
- Next by thread: Re: How do I empty a table?
- Index(es):
Relevant Pages
|
