Delete a table in another database

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top