An accde or mde created in Access 2007 SP1 can't be read in Access 2007 no SP.
Error message when you try to open a compiled database file or a compiled project file in Access 2007: "This database is in an unrecognized format"
Some Microsoft Access MDB Corruption Symptoms page has been updated accordingly
Is there a workaround for this? It causes my Access 2007 Runtime applications to fail when they're compiled under Access 2007 SP1, and that makes my customers mighty unhappy!
No, all you can do is make the mde/accde in an Access 2007 system wihout SP1.
Is there a way to raise the Runtime to SP1 ?
At thsi point no. The Office 2007 SP1 does not detect the A2007 runtime. I'm sure this will be rapidly fixed by Microsoft.
I have a second computer that I disabled automatic updating on. I use that to compile the program on before distributing.
It is a royal pain besides costing time.
I've tried to uninstall just the Access 2007 and re-install again only Access 2007 but still the same.... :_(
Perhaps, it's really need to uninstall the whole Office suite and re-install again.
What a nuisance this is! Let's hope Microsoft DO fix this sometime soon!
Same problem with runtime, Any fix yet?
To prevent the error "This database is in an unrecognized format" from appearing, copy the MSAccess.exe file from the PC that has MS Office SP1 to the PC without. This should fix the problem.
Solution:
Copy MSAccess.exe from the PC with Office 2007 SP1
into the PC with MS Access Runtime 2007. Overite the existing file.
I've just received a hotfix from Microsoft which is supposed to fix this problem and it didn't work. The hotfix is dated 28 January 2008. Has anyone else tried this hotfix see
support.microsoft.com/kb/943249
I am reluctant to go back to Access 2007 without SP1, so will wait to see what Microsoft suggest.
I am using a very standard back end data file in .ACCDB format with a front end interface file in .ACCDE format to protect my code, forms, reports, etc.. As I am about to distribute my application, this is a real worry...
I've just downloaded and installed the new Access Runtime Version 2 released on March 28, and am delighted to report that it solves the problem with .ACCDE and SP1. No need for hotfixes, just the real thing...