create DB access table during runtime in VB 6

[kudar@programmer]

hi. VB6 FAQ

i been tasked to write an order tracing system for the sales dept and so in some instances i need to create a table during runtime. how do i go about it

 

[DCrake]

Under what cirumstances would you want to create a table? All tables should already exist.

 

[kudar@programmer]

i wanted to create it when updating some of the orders so as to keep track of the dates when those orders were updated.
the thing is like
when a customer comes and gives us an order, we enter the order in the DB. say the order is for 10000 boxes. if the factory guys run 5000 boxes on a particular day and the other remaining on other days, i would want to keep track of the days the boxes were run. how do i keep track of the dates