help with my database!!!1

ok, here is the next problem i am faced with.

If the user of my app wants to load a new file, i need to delete all the entries within my database table. what would be best way to do that

i was thinking

do while not rs.eof

rs.delete

thanks for all the help everyone

just use

Code:

---


delete from tablename

---

As your query to delette all the records.:)

He means use a query to delete everything from the table :

'---- Like this - replace tablename with the right tablename tho
dbengine(0)(0).execute "Delete * from tablename;"

Regards

Vince