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 connot be a linked table. Please help.

Regards,

Richard

 

[Dennisk]

why not just open the database, then the table then delete all the records

 

[LWCARAB]

Because this must happen each time the database is opened, even if I automated the open and delete part, it would take a while.

 

[Mike375]

An autoexec macro running OpenQuery for a DelteQuery or DeleteObject if the table itslelf is to be deleted

 

[Dennisk]

Sorry I meant do it all in code, not manually. Search Help for workspace and open recordset

 

[georgedwilkinson]

Use DAO or ADO automation. Lots of information out there how to do this.

 

[Guus2005]

Executed from another database it will delete all records from "sometable" in database aap.mdb

currentdb.execute "delete from sometable in 'c:\temp\aap.mdb'"

HTH

 

[Rabbie]

This question has already been answered in this thread

 

[Guus2005]

Thank you for pointing that out.