• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

Delete Access2k table from VB

a code snippet any1 :o)
0
djdidge
Asked:
djdidge
  • 3
  • 3
  • 2
1 Solution
 
AmitabhCommented:

strsql = "delete from NCT_mast"
prs.Open strsql, conn

hope this is what u want
0
 
AmitabhCommented:
here NCT_Mast is the table u want to delete and conn is the connection with ur access2K mdb.
0
 
ajexpertCommented:
if you want to drop table then following snippet may help


cn.execute " DROP table <your tablename>"
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
djdidgeAuthor Commented:
thanks for your reply...but it doesnt seem to do anything
0
 
djdidgeAuthor Commented:
is DROP the term used to remove a table from the DB? (not the records)
0
 
AmitabhCommented:
yes if u want to remove the table use drop as aj said.
0
 
ajexpertCommented:
does it gave any error.  if so, what is the error message
0
 
djdidgeAuthor Commented:
Thanks both for responding quickly!

ajexpert you get the points coz "DROP table" worked for me


Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now