Export Data to Ms Access file from Sql

Mar 26 2011 8:47 AM

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!