Need to open SQL server .bak file in Access to restore some corrupt data
Posted on 2007-04-05
Our website runs on a SQL server. Recently we had some data corrupted in a specific column of a table. I was able to get our host to provide a back up file. the file they gave me is a ".bak" file. i dont have access to the SQL server directly, only through MS Access. How do i open up this .bak file with Access so that i can write an Update Query between the two tables to copy the missing data and put it back into the live site.