Deleting tables

[Darci]

Hi,

I am trying to write a function that will open a database from a database and delete certain tables on a click event. In other words, I am working from a form in database A, and on that form is a button that I can click to delete a table in Database B. Any suggestions?

Thanks in advance

 

[Quehay]

Something like this (in DAO):

Set Db_External = Workspaces.Open targetDb

For i = 0 to Ubound(ArrayofTableNames())

Db.Tdfs.Delete ArrayofTableNames(i)

Next

Jeff Roberts
Analysis, Design, & Implementation
RenaissanceData.com