Delete Database information

In my applicaton I have created an Access Database where I am populating it with file information.(The mdb file is stored locally)

Example
File Information Table

# | Path | File | Created On | Modified Date | Version Info | Description

Can someone please tell me how I would go about deleteing all the records stored in each column and row?

I have tried to close and unload the recordset and then delete the entire mdb file but have had no luck. So I thought if rather than trying to delete the database I could just clear all the information out of it.


The reason why I am wanting to do this is so the user doesnt have to close the application and reopen it to build a new package.

Any suggestion would be greatly appreciated!!!!
Thanks
Tcompe

[Lothar Haensler]

try using standard SQL:
DELETE FROM yourTableName;

Thanks
I dont know what I was thinking.... That worked perfectly....

Thanks agian