Agreed. Powershell is a lot less complicated (even with script signing) and allows for weekly, monthly and annual archiving from a single daily backup file.

...and like most other DML actions:

Always wrap the commands in USE [database]; BEGIN TRAN...COMMIT/ROLLBACK TRAN.

Won't be of much use with TRUNCATE TABLE but transaction control is always important when modifying...

Supply & Demand:

Good-Excellent developers/engineers are hard to find and should command what the market will bear.

'Good' salespeople are easy to find but excellent reps should be compensated based on...

If done properly linking an Access Database via a SQL Server Linked Server should allow you to read and update the Access data as if it were native SQL Server...