I have built an ACCDB database for my comics.  I haven’t yet made the DB relational. I was mostly working on getting my records into the database, and the basic record, which is long but almost all related to individual issues, consists of Publisher Code, Issue Name, Volume Number, Issue Number, copyright year, month of publication (like 01, 02, 03), Box number (where it’s stored) and, as an attachment (not an OLE object) a picture of the cover.  The database is large.

Yesterday, I noticed a problem when I tried to attach an image to a record.  I can almost complete the process, but at the “commit,” I get a popup “Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.”

I have tried to “Compact and Repair” the database with miserable results. It creates a table (an MDB table, no less) with several system errors.

I spent some time with a Microsoft Tech Support person a few minutes ago, but we didn’t accomplish anything useful.  To be complete, we opened MSAccess from the CMD prompt using “MSACCESS.EXE /decompile” (no problem), then opened the actual corrupt ACCDB file from the command prompt (no evident problem), but when I tried to Save As (new file name), the Save As process locked up after about 1,800,000 KB of processing, and I had to kill it.

Any suggestions welcome.  I have used OneDrive to try and roll back the corrupt file to a previous version (not too far back, because I’ve put in a lot of work this week!), but those older versions still seem to have the Compact and Repair problem.  

​I have built an ACCDB database for my comics.  I haven’t yet made the DB relational. I was mostly working on getting my records into the database, and the basic record, which is long but almost all related to individual issues, consists of Publisher Code, Issue Name, Volume Number, Issue Number, copyright year, month of publication (like 01, 02, 03), Box number (where it’s stored) and, as an attachment (not an OLE object) a picture of the cover.  The database is large.Yesterday, I noticed a problem when I tried to attach an image to a record.  I can almost complete the process, but at the “commit,” I get a popup “Cannot open database ”. It may not be a database that your application recognizes, or the file may be corrupt.”I have tried to “Compact and Repair” the database with miserable results. It creates a table (an MDB table, no less) with several system errors.I spent some time with a Microsoft Tech Support person a few minutes ago, but we didn’t accomplish anything useful.  To be complete, we opened MSAccess from the CMD prompt using “MSACCESS.EXE /decompile” (no problem), then opened the actual corrupt ACCDB file from the command prompt (no evident problem), but when I tried to Save As (new file name), the Save As process locked up after about 1,800,000 KB of processing, and I had to kill it.Any suggestions welcome.  I have used OneDrive to try and roll back the corrupt file to a previous version (not too far back, because I’ve put in a lot of work this week!), but those older versions still seem to have the Compact and Repair problem.    Read More

​