Is there a way to delete every record in a table without selecting all the rows

[jamie]

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks

[Larry Linson]

Don't try to do this from datasheet view.

Create a Delete Query in the Query Builder and execute it: Add the Table to
the Query, drag down the * into the grid, then on the menu, click Query and
choose Delete. Execute it with the ! icon on the toolbar. Don't be
impatient, as with a million rows, it will take some time.

Larry Linson
Microsoft Access MVP
<ja***@cd-worx.com> wrote in message
news:40**************@news.clari.net.au...

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks

[jamie]

Thanks a lot. Will give it a go.
On Tue, 29 Jun 2004 01:14:40 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

Don't try to do this from datasheet view.

Create a Delete Query in the Query Builder and execute it: Add the Table to
the Query, drag down the * into the grid, then on the menu, click Query and
choose Delete. Execute it with the ! icon on the toolbar. Don't be
impatient, as with a million rows, it will take some time.

Larry Linson
Microsoft Access MVP
<ja***@cd-worx.com> wrote in message
news:40**************@news.clari.net.au...

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks

[John Baker]

Set up a select query which selects the whole table (i.e with no criteria) and then change
it to a delete query! Then run it!

Best

John Baker
ja***@cd-worx.com (ja***@cd-worx.com) wrote:

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks

[David Schofield]

On Mon, 04 Oct 2004 11:33:55 GMT, John Baker <Ba******@Verizon.net>
wrote:

Set up a select query which selects the whole table (i.e with no criteria) and then change
it to a delete query! Then run it!

Best

John Baker
ja***@cd-worx.com (ja***@cd-worx.com) wrote:

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks

Hi
It can take a long time to delete a million rows. If at all possible I
would delete (kill, drop) the table and replace it from an empty copy.
However this will not be easy if there are external relationships.
David

[Alan Webb]

John,
The SQL for it will look something like this: "DELETE TABLE_1.* FROM
TABLE_1;". That gets rid of every row in the table. It will fail (as
others here have said) if the errors you are getting are due to constraints
in place on the table. If you wanted a script that really would dump a
million rows without complaining about constraint violations you would have
to include a number of "ALTER TABLE_2 DROP CONSTRAINT . . . " sorts of
statements to get rid of the constraints first, then delete your rows.

"John Baker" <Ba******@Verizon.net> wrote in message
news:b7********************************@4ax.com...

Set up a select query which selects the whole table (i.e with no criteria)
and then change
it to a delete query! Then run it!

Best

John Baker
ja***@cd-worx.com (ja***@cd-worx.com) wrote:

Hi,

I have a table with 1 million rows that I need to delete.

Is there a way to delete them quickly considering I get errors if I
try to select them all and then hit delete?

What I'm looking for is some sort of "delete all records" menu option.

Thanks