Access 2007: "This database is in an unrecognized format"

re: Access 2007: "This database is in an unrecognized format"

jack allen — Wed, 22 Jul 2009 01:48:55 GMT

I get this error with Access 2007 in this situation: If I place the db on my local server, copy it right back, open the db I get the error. If I use a thumbdrive to copy it everything works just fine. If I use an older version of my database it works fine when I place it on the server, copy it back and open it. I have tried to compact and repair, but it makes no difference.

Any ideas?

jack

re: Access 2007: "This database is in an unrecognized format"

Carlos Machado — Tue, 02 Jun 2009 14:27:29 GMT

Hi:

Try this from a Visual Basic Program:

DBEngine.CompactDatabase NameDB_Failure, NewDB.mdb

bye.

Carlos Machado.

cmachado@tinglesa.com.uy

re: Access 2007: "This database is in an unrecognized format"

Sambodh — Mon, 31 Mar 2008 08:13:17 GMT

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...

re: Access 2007: "This database is in an unrecognized format"

Sambodh — Mon, 31 Mar 2008 00:58:30 GMT

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...

re: Access 2007: "This database is in an unrecognized format"

Gina Yazbek — Thu, 14 Feb 2008 04:12:44 GMT

Solution:

Copy MSAccess.exe from the PC with Office 2007 SP1

into the PC with MS Access Runtime 2007. Overite the existing file.

re: Access 2007: "This database is in an unrecognized format"

Gina Yazbek — Wed, 13 Feb 2008 11:22:27 GMT

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.

re: Access 2007: "This database is in an unrecognized format"

DjNico — Mon, 11 Feb 2008 09:56:46 GMT

Same problem with runtime, Any fix yet?

re: Access 2007: "This database is in an unrecognized format"

RP — Sat, 19 Jan 2008 17:37:25 GMT

What a nuisance this is! Let's hope Microsoft DO fix this sometime soon!

re: Access 2007: "This database is in an unrecognized format"

BC Lee — Wed, 16 Jan 2008 16:10:32 GMT

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.

re: Access 2007: "This database is in an unrecognized format"

Jan Poller — Tue, 01 Jan 2008 20:59:12 GMT

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.

re: Access 2007: "This database is in an unrecognized format"

Tony — Fri, 28 Dec 2007 19:19:57 GMT

At thsi point no. The Office 2007 SP1 does not detect the A2007 runtime. I'm sure this will be rapidly fixed by Microsoft.

re: Access 2007: "This database is in an unrecognized format"

Ken Pascoe — Fri, 28 Dec 2007 14:11:43 GMT

Is there a way to raise the Runtime to SP1 ?

re: Access 2007: "This database is in an unrecognized format"

Tony — Fri, 28 Dec 2007 00:54:50 GMT

No, all you can do is make the mde/accde in an Access 2007 system wihout SP1.

re: Access 2007: "This database is in an unrecognized format"

Lisa Way — Thu, 27 Dec 2007 22:42:23 GMT

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!