Delete data from a *.mdb file

[Asterix]

I need to delete old data from a *.mdb file.

In the database there is a column with the timestamp of the logged data.

I need a Query to delete the data from 15-3-00.




ID ProductNr TimeStamp ProductName
88 1 15-3-00 17:50:51 Test1
89 1 15-3-00 17:51:51 Test1
90 2 15-3-00 17:52:50 Test2
91 2 15-3-00 17:53:51 Test2
92 2 15-3-00 17:54:50 Test2
93 2 15-3-00 17:55:51 Test2
94 2 16-3-00 9:18:13 Test2
95 2 16-3-00 9:19:12 Test2
96 3 16-3-00 9:20:12 Test3
97 3 16-3-00 9:21:12 Test3
98 1 16-3-00 9:22:13 Test1

Thanx

[Forest Dragon]

Try this:

DELETE * FROM YourTableName WHERE TimeStamp>=#15/03/2000#

Good Luck!!!