Clearing contents of a table

[JAVANUT]

I am currently using access 2k(mdb). I am creating a
table to store output of a query. I then use this data to
link to a another program that prints labels.

Everything works fine, however I am having problems when
I run the make table query with new data. My question is:
How can I clear the data in the output table so that I
can then populate it with the new data? In addition, how
can I eliminate the prompt that I warns me about deleting
data(perhaps the first answer solves this)?

many thanks in advance,

Javanut

 

[Allen Browne]

Try:
strSQL = "DELETE FROM MyTable;"
dbEngine(0)(0).Execute strSQL, dbFailOnError

 

[JAVANUT]

thanks, I will give it a try

-----Original Message-----
Try:
strSQL = "DELETE FROM MyTable;"
dbEngine(0)(0).Execute strSQL, dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.