help with my database!!!1

[jk9694]

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

[veryjonny]

just use

delete from tablename

As your query to delette all the records.

[Ecniv]

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