Deleting objects in another DB

[Mota]

Hello;
How to Delete or Rename a table from another Database (other than the DB im
coding in),while im in the CurrentDB?
Thank you for your help.

 

[Arvin Meyer]

In your code, instead of opening or referencing the CurrentDB, use the path
to the database you want to talk to:

Dim db As DAO.Database
Set db = "C:\Blah|Blah.mdb"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mota]

Ok,then how to delete a table from inside this db.Can i use
DoCmd.DeleteObject and be sure that tables in db will be deleted,rather than
a table with the same name in currentDB?
Thank you for ur help.

 

[Paul Overway]

No, if you use DeleteObject, it will delete from currentdb (or possibly
codedb if you're running the code from an add-in). If you want to delete a
table or a query, Arvin's suggestion will work...

Set db = OpenDatabase("path to database")

db.TableDefs.Delete "some table"
db.QueryDefs.Delete "some query"


HOWEVER, if you're trying to delete a form or any other object other than
tables or queries, you would need to instantiate another Application object
and use automation, i.e.,

Set app = New Access.Application

app.OpenCurrentDatabase "path to database here"

app.Docmd.DeleteObject [objType], [objName]

app.Quit

 

[Mota]

Thank you for ur help.

No, if you use DeleteObject, it will delete from currentdb (or possibly
codedb if you're running the code from an add-in). If you want to delete a
table or a query, Arvin's suggestion will work...

Set db = OpenDatabase("path to database")

db.TableDefs.Delete "some table"
db.QueryDefs.Delete "some query"


HOWEVER, if you're trying to delete a form or any other object other than
tables or queries, you would need to instantiate another Application object
and use automation, i.e.,

Set app = New Access.Application

app.OpenCurrentDatabase "path to database here"

app.Docmd.DeleteObject [objType], [objName]

app.Quit

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com

Ok,then how to delete a table from inside this db.Can i use
DoCmd.DeleteObject and be sure that tables in db will be deleted,rather
than
a table with the same name in currentDB?
Thank you for ur help.