Clearing contents of a table

  • Thread starter Thread starter JAVANUT
  • Start date Start date
J

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
 
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.




.
Click to expand...
 
Back
Top