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...

Thank you Brunm and Jack for your answers!

With Jacks solution it works like a charm.

I also tried with Brunms solution but I could not get it to work properly. I...

Thanks a lot Brunm

Today I am traveling so I can not try but I will do it first thing tomorrow an let you know my progress.

/Bo

Thanks.

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.

Bo Lausten-Thomsen