Delete a table in another database

G

Gerald Stanley

Try something along the following lines

Dim appAccess As Application
Dim db As Database

Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "C:\Access\MyDatabase.MDB"
Set db = appAccess.CurrentDb
db.TableDefs.Delete "MyTable"

Set db = Nothing
appAccess.Quit
Set appAccess = Nothing

Hope This Helps
Gerald Stanley MCSD
 
T

Tim Ferguson

How does one delete a table in a different database through VB code?
Click to expand...

set db = opendatabase("d:\differentdatabase.mdb")

db.Execute "DROP TABLE SomeTable", dbfailonerror

db.close


Hope that helps


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Can't seem to delete all images from a Word Doc 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Creating a Search using a combo box and then creating a report. 4
Word VBA - Delete text from bulleted paragraphs 1
Create a chart from a table in word thats dynamic 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Code to cut a paragraph that's followed by a table 2

Top