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!

Crish · Answer

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

Mahesh Chand · Answer

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.