Delete large numbers records from Linked Table

[JAMBAI]

Hi,

How to delete large numbers (100,000 - 1,000,000) records from linked table.

I am trying to delete from MS Access Forms.

Thanks
Jambai

[Denburt]

Hi,
How to delete large numbers (100,000 - 1,000,000) records from linked table.

I am trying to delete from MS Access Forms.

Thanks
Jambai

This question tells me almost nothing. I am going to have to render a guess and say that you have a single form and can only delete 1 at a time right now correct?
There are a lot of ways that this can be accomplished but you need to know what table this information is stored in and if deleting them will delete records in other tables. Please try and provide us with a little more info. Thanks

[NeoPa]

You can use the SQL DELETE statement.
Exactly how to specify what you need we can't tell you but here's a start.

DELETE Statement
Creates a delete query that removes records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause.

Syntax
DELETE [table.*]
FROM table
WHERE criteria

The DELETE statement has these parts:

Part Description
table The optional name of the table from which records are deleted.
table The name of the table from which records are deleted.
criteria An expression that determines which records to delete.