Clearing Table in another database

[LWCARAB]

I urgently need a way to clear a table in a different access database, this table is not and cannot be a linked table. Please help.

Regards,

Richard

 

[ecawilkinson]

Try this:

    Dim db As Database
    
    Set db = DBEngine.OpenDatabase("c:\targetDB.mdb")
    
    db.Execute "delete * from TableToClear"
    
    db.Close
    Set db = Nothing

HTH,
Chris

 

[LWCARAB]

Brilliant! Thanks so much, you're a life saver.

Richard