Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    deleting remote module (Access 2000)

    I want to delete a module in another database.I have a code that deletes a table and it is the folowing
    Public Function FRemote()
    Dim cat As New ADOX.Catalog, objConn As New ADODB.Connection
    objConn.Open "Provider= Microsoft.Jet.OLEDB.4.0;Data Source = C:bestorebe.mdb"
    With cat
    .ActiveConnection = objConn
    .Tables.Delete "products"
    End With

    My question is, how can i delete the module MdlProductsd in another database?
    With the above code i can delete only tables but not modules.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: deleting remote module (Access 2000)

    There's an AllModules container in the currentproject, but I've never tried to delete anything from it. Each AccessObject in the container object can be enumerated, but they may be read only. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Why are you trying to delete a module in a remote database? If you want to update it, it isn't hard to replace the code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts