Export Data to Ms Access file from Sql

Question

Hi friends,

I have exported sql table data to ms access table.
Then iam trying to make copy of access file and then rename its name to todaysdate and then compress to it.

i have tried  compress code but it gives me error file is in used!!!!!


Plz give me solution!