Forum Discussion
This Object was saved in an invalid format and cannot be read
This is, unfortunately, not uncommon. Not frequent but certainly it does happen.
That form is corrupted. Fortunately, it sounds like only that one form is bad. And two reports I guess?
It could be the entire accdb! That happens also.
So, recovery. Your backups appear to have been saved with the corruption already present in the form(s) and report(s). Bad, but not the end of the world.
One approach is to start over with a clean, new accdb and import everything into it EXCEPT those objects that are corrupted. Then recreate them from scratch. A lot of frustrating work if you can't get the good versions from backups.
You can also try a couple of other trouble-shooting steps on a COPY of the accdb. Use a copy in case your trouble-shooting goes wrong.
One common approach is outlined in this article This is known as decompile/compile and many developers have rescued their applications that way. Not all, unfortunately, but some.
Note that FMS is a third-party vendor or Access tools, but I have no interest in the business other than respect for their competence.
Another approach is the undocumented, but often successful, Save As Text method documented on Allen Browne's site. It's part of a series of things he discusses.
Good luck and please let us know if you are successful.
George_Hepworth Thank you so much for the reply! I've now tried to decompile and recompile, unfortunately that has not solved the issue, I'll try this save as a text file method.
I'm really not that experienced at access but I find it very curious that this error only happens on my main computer, when I launch the database on the data entry computer it prints the report just fine, Also I tried editing the reports on another 3rd computer and it worked until recently (now it throws the same error).
Would you know if splitting the database will prevent this error?
Again thank you so much for your time! I really appreciate the help , I'll keep the forum updated!
- George_HepworthNov 30, 2020Silver Contributor
Splitting the accdb probably wouldn't make that much difference but it's always a good idea to split every relational database application in any event.
The difference between behavior on different computers may be related to different version of Office. Is everyone working with the same version?
- Chris_AmstutzDec 01, 2020Copper Contributor
It looks like everyone is on Access 2016, would there be different software versions (like v1.01 or something of that sort?).
- George_HepworthDec 01, 2020Silver Contributor
Hm. I just re-read your initial post. I forgot you had not yet split the accdb into the Interface components in a Front End and the data in tables in a Back End.
Do that now. Do it with a known good copy of the accdb. Put the BE in a shared location. Give every user their own copy of the known good FE. Keep a master copy of the known good FE away from any other user so you can recover from it if necessary. Never let two users open the same copy of an FE.
And make sure your data is backed up regularly (daily or more often would be better.)