Is this possible?

[Tony Ciconte]

Is it possible to delete objects in one MDB file from another MDB
file? Specifically, is it possible to delete a query, form, report.
etc. from MDB #1 by opening MDB #2 and performing some action or
running VBA code to affect the objects in MDB #1?

If it is possible, does anyone know how it is done and/or could share
some code that would accomplish this or get me started?

Any and all help is greatly appreciated.

TC

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use Automation to open the other .mdb file. See the help articles on
GetObject Function and CreateObject Function. Something like this:

dim acObj as Object
set acObj = CreateObject("Access.Application")

' Access 2K2 example
acObj.DoCmd.DeleteObject acTable, "Table Name"

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP+JpQoechKqOuFEgEQJlZQCg18nDEP2APA8VLUhOkghH5+ p9AuQAn0yy
Qq3ePVrzz5SSkrDvR6+VQUAj
=rU67
-----END PGP SIGNATURE-----

Tony Ciconte wrote:

Is it possible to delete objects in one MDB file from another MDB
file? Specifically, is it possible to delete a query, form, report.
etc. from MDB #1 by opening MDB #2 and performing some action or
running VBA code to affect the objects in MDB #1?

If it is possible, does anyone know how it is done and/or could share
some code that would accomplish this or get me started?

Any and all help is greatly appreciated.

TC