clear access table from vb

[jono261970]

Hi,

is it possible to clear an access table before I add to it?

I am using the DAO "rs1.addnew" command to add data to the current fields. I would like to empty the table each time I call the routine that adds the data.


hope this makes sense!

thaks in advance.

jono



A good fortune may forbode a bad luck, which may in turn disguise a good fortune.

 

[Golom]

You could simply delete everything like this

db.Execute "Delete * From tbl"

 

[jono261970]

Thanks buddy!

That did the trick.

jono
]

A good fortune may forbode a bad luck, which may in turn disguise a good fortune.