Your suggestion will work nice with when the database is in SQL Server but when the database is in MS Access you can not use namned varible (@Department_id ), you...
I dropped the table, stopped SQL Server, deleted the file distribution.ldf, restarted SQL Server and the file distribution.ldf reappeared (still no distribution.mdf) so the problem still exists.