I backuped some SQL Server 2008 R2 databases using .bak files within SSMS, I sent them to a client and they're willing to open them within MS Access.

Can you please tell me if this is possible and if limitations exists to perfmrom this procedures?

My bak files are 40GB aprox

Thanks in advance

2 Answers 2


It is not possible to restore a SQL Server backup into MS Access.


MS Access does not support that kind of action. I believe your best bet wold be to create a MS Access database and export the data from SQL Management Studio to the access database file. You can also try to export to flat file CSV and have them import it that way.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.