Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleting an Access Table using VB.

Status
Not open for further replies.
Gaff

Gaff

Programmer
Dec 13, 2001
30
IE
I'm trying to Delete an Access table using VB. I don't even know if this is possible. I couldn't even do it using SQl in Access. I know in Oracle there is the DROP table method and i was wondering if there is any similar method in Access, and then i could just execute it from the VB frontend. Thanks.
 
Sort by date Sort by votes
DROP is an SQL statement and is used to delete links to tables.

If you want to delete a local table (not linked) in VB then use DoCmd.DeleteObject.

Does this help?

Ed Metcalfe.
 
Upvote 0 Downvote
Ya that is exactly what i wanted.Works fine. Thanks Ed
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Question
scraping table in web page 3
2
Replies
24
Views
2K
strongm
strongm
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
395
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
195
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
321
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
176
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top