I work with an application called Toad for Oracle. All I use it for are custom reports and to copy 12 tables out of our database once a month for a project I'm working on. I have on occasion used it to trace the SQL taking place behind the scenes on different canned reports.

After playing around with the export settings, the fastest way to get data out of these tables thus far has been to export to MS Access files.  I would save them locally and then after completing that task, I move them to a server on the network.

This server on the network is my playground so to speak.  It has MS SQL 2012 installed along with all the SQL suite of tools. This is where I'm going to develop a database to de-normalize the data for the purposes of custom reporting. The database that I'm pulling this from was designed in a very bad way. If you try and use the SUM() function on one of the fields containing money amounts, it could take 18 hours to finish.

Anyway, after logging into this server (my login is a domain admin and I have admin rights on this server), I tried opening up one of the MS Access files and I got the following error...

The version of Access used to save this database cannot be detected. this problem cannot be corrected because the database is read-only. Click OK, and after the database closes, make a backup copy of the database. Then open the database with read/write permission.

These files are *.accdb files and I believe Toad for Oracle exports into a 2007 format. The files are on the local E:\ drive. I'm using Access 2013 on that server.  Googling that error pointed me to forum posts that explained issues that were somewhat similar but not completely. They talked about not having the rights to the directory the files are located in but I knew that couldn't be right since I have admin rights and I use the same login to transfer the files as I am trying to open the files.

Just for kicks, I copied the file from one directory to another and I was finally able to open the file.