How can i erase or Delete entire table.?

Question

from m.s. access thorough v.b. coding

Answer 1

if you want to delete ur ms access table code from your vb program, then you have to go the codebehind of your program..(eg. program name is lala.aspx, you doubleclick any area in the program and another program (the codebehind) called lala.aspx.vb will appear). then you look for the table name at the .vb program which you gave initially in the .aspx program. delete the part where there is C:/name of the ms access program/name of the ms access table(this part shows the link of the ms access table to the vb program).

by deleting this link (assume that initially you already specify it), the information of everything in the table which is taken from ms access will not show up. but this does not delete whatever in ms access.
however if you did not even specify the link, then your ms access code is not even in the vb program.

so to delete the table from ms access, just right click on the table name and click delete.

it is hard to explain here..hope you manage it.

Answer 2

slect the whole table by CtrlA and then delete, simple

Answer 3

yes you should--with a 2 points here and a 2 points there here a point there a point everywhere a point point

Answer 4

use this query:
TRUNCATE TABLE table_name
or
DELETE * FROM table_name

you know query?
sample connection.open("query")