Delete records from table in ANOTHER database

[kathywebster]

I am a novice at VBA. I would like to implement it to delete all records from a temp table in another database. In other words, I want to write code in Database_A to delete all records from t_temp in Database_B. Can you help?
Thanks so much!

 

[MarkK]

I believe you can use the IN keyword, and enclose the path to the database file in single quotes, so something like...

CurrentDb.Execute "DELETE FROM SomeTable IN 'C:\SomeOther\Database.mdb'"

Mark

 

[kathywebster]

Brilliant! Thank you!