Export Data to Ms Access file from Sql

when MSAccess database is opened for reading then if you can try to edit /change then it shows this error file is in used. first close MS Dataaccess  then try your code

By default, the MS Access is open exclusive to a single database only. Before you can compress is, you MUST close any kind of connection with the access database.

OR you can open an Access file non-exclusive using the connection string by adding "Mode=Shared;" to your connection string.