Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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