Was getting the following error when running a “join/select into” query in MS Access
“Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.”
I followed a bunch of suggestions I had found on the web … especially this post which had suggested that I should reinstall Jet (which led me to this post which suggested I ultimately needed to reinstall Windows XP SP2 … which in a slipstream install means that the entire OS needs to be reinstalled!)
Ultimately, I was able to solve this problem by simply saving the database in MS Access 2003 format (.mdb) from the 2007 format I had stored it in (.accdb). I was able to run the query from the mdb and then resaved back into Access 2007 format, where I am again able to re-rerun the query.