By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,665 Members | 1,900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,665 IT Pros & Developers. It's quick & easy.

Delete large numbers records from Linked Table

JAMBAI
P: 28
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
Apr 16 '07 #1
Share this Question
Share on Google+
2 Replies


Denburt
Expert 100+
P: 1,356
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
Apr 20 '07 #2

NeoPa
Expert Mod 15k+
P: 31,561
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.
Apr 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.