deleting info from table

[benjy5]

I'm coding in Access 97 and having some difficulty deleting all records from a table without actually deleting the table itself. I'm using the code: db.tabledefs("name").delete . Is there another function that will delete all the records ? Someone showed me on a macro that there is a command, but i can't find it in VBA. Any suggestions?

Thanks!!

 

[Rich]

Look up Delete queries, or the SQL for one.