Re: How do I empty a table?

You write a series of queries that delete data from each table.
Delete the records in any child tables before you delete the records in any
parent tables.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"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


.

Relevant Pages

  • Safely timing out DBI queries
    ... plenty of data and hence plenty of rope. ... themselves by timing-out long-running queries and killing the MySQL ... Parent forks a child before starting long-running query. ...
    (perl.dbi.users)
  • Re: Difficulty in implementing
    ... The textual content in the parent table will make the "table wider". ... textual column is involved in other queries, storing it in a child table ... you will get better performance by storing it in a child ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Insert records in Parent and child tables
    ... MS Access MVP ... Child table is the Parent ID. ... Create an append query based on the union query. ...
    (microsoft.public.access.queries)
  • Re: Insert records in Parent and child tables
    ... Child table is the Parent ID. ... MS Access MVP ... Do I have to use a union query 3 times to add the child? ...
    (microsoft.public.access.queries)
  • Please help
    ... LotId can have 1-8 components). ... Both parent and child ... When I run queries on ... it best to copy that information from parent to child lot. ...
    (microsoft.public.access.tablesdbdesign)