Apr 24th, 2000, 11:36 AM
Is anyone aware of any commands for purging of a table in an access database? That is, I would like to delete all the data in it but not the structure. I am at the moment working between two tables and constantly need to clear data in them. So what I am doing now is killing the table and recreating them again. Surely there must be a way of purging the data without having to recreate the whole table. If anyone has any suggestions, I would greatly appreciate it.
Thank you.
Ben
benni@sydney.cbr.com.au
Thank you.
Ben
benni@sydney.cbr.com.au