deleting an object in another database

[windandwaves]

Hi Folk

I am trying to delete an object in another database, but from reading the
google newsgroup archives, it seems that this is not possible. Does anyone
know any easy work-arounds? Can you use the docmd.copy thing and override
the old one?

Cheers

- Nicolaas

[Br]

windandwaves <wi*********@coldmail.com> wrote:

Hi Folk

I am trying to delete an object in another database, but from reading
the google newsgroup archives, it seems that this is not possible.
Does anyone know any easy work-arounds? Can you use the docmd.copy
thing and override the old one?

Cheers

- Nicolaas

You can certainly reference an external database and there should be no
reason you can't delete an object from it.

Something like..

Dim myDB as Datbase
Set myDB = OpenDatabase("c:\MySecondDB.mdb")
myDB.TableDefs("tblDeleteMe").Delete

(look up the help for syntax etc.. I'm "making it up" as I type :)

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[windandwaves]

Br@dley wrote:

windandwaves <wi*********@coldmail.com> wrote:

Hi Folk

I am trying to delete an object in another database, but from reading
the google newsgroup archives, it seems that this is not possible.
Does anyone know any easy work-arounds? Can you use the docmd.copy
thing and override the old one?

Cheers

- Nicolaas

You can certainly reference an external database and there should be
no reason you can't delete an object from it.

Something like..

Dim myDB as Datbase
Set myDB = OpenDatabase("c:\MySecondDB.mdb")
myDB.TableDefs("tblDeleteMe").Delete

(look up the help for syntax etc.. I'm "making it up" as I type :)

Hi Bradly

That works for tabledefs and querydefs, but I need to delete modules and
forms..... and I do not think that this works.

[Chuck Grimsby]

Dim objAcc As Access.Application
Set objAcc = GetObject("C:\myOldDB.mdb")
objAcc..DoCmd.DeleteObject acForm, "frmBad"
objAcc.Application.Quit
Set objAcc = Nothing