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!

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

Delete table from backend database 1

Status
Not open for further replies.

KKit

Technical User
Jun 13, 2007
28
CA
I am running an application with both a front end and a back end. I have my tables linked in my front end to the back end (pretty standard!) Both of them are Microsoft Access databases.

How do I delete a table from my front end into my backend database? If you use "drop table", then it drops the link from the FE. If you use "docmd.deleteobject", it does the same thing.

There has to be another command out there, but I just can't seem to find something that works!


Thanks for your help!
 
How about:

Code:
Dim db As DAO.Database
Set db = OpenDatabase("C:\Doc\Tek-Tips.mdb")
strSQL = "DROP TABLE tblTable"
db.Execute strSQL
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top