create a query to delete all records in a table

[Dave F]

Is it possible to create a query which deletes all records in a table? Sort
of a reverse append query?

 

[Jeff L]

Delete From YourTableName

Hope that helps!

 

[Ofer Cohen]

Before trying anything back up your data

Try

DELETE TableName.* FROM TableName

 

[Dave F]

Thanks.
--
Brevity is the soul of wit.

Before trying anything back up your data

Try

DELETE TableName.* FROM TableName

 

[Mike]

Yes you can do it in code, here is a sample:
DoCmd.RunSQL "delete * from [842-2486 Heads]"
where "[842-2486 Heads]" is the name of the table.
Or you can create a delete query by selecting the query type in the query
section of access.
let me know if this helps.

 

[CZ]

Type SQL code

Delete [table name].[ID], [table name].[additional name] From [table name]
Where ((([table name].[ID])>0));