Access2010无法打开应用程序较早版本创建的数据库

乐梵

office安装好之后，不管是新建空数据库，还是打开已有的数据库，都提示“无法打开应用程序较早版本创建的数据库”，重装office后无果，office和windows都是32位的，已激活。

qfxfox

https://social.msdn.microsoft.com/Forums/office/en-US/153a2da8-f366-44cf-a07c-dd214f9e25fd/access-2013-cant-create-new-dbs?forum=accessdev

I had the same problem and removed the %USERPROFILE%\AppData\Roaming\Microsoft\Access\System.mdw file.

This resolved my problem.


Yes, it turns out the MDW was the problem.  We have been using  Access for a long time with the built-in user accounts feature.  The security info is stored in an MDW file.  This file was in an old version that unfortunately Access 2013 cannot read.  Here are the steps to revert back to the default MDW that comes with Access:

1.  Press Ctrl-G as soon as Access starts which will bring you to the Visual Basic editor.

2.  Type --> docmd.RunCommand acCmdWorkgroupAdministrator

3.  Then specify the default MDW which is located at:  C:\Users\<YOUR NAME>\AppData\Roaming\Microsoft\Access\System.mdw

Next I upgraded the MDW file.  To do this you will need an older version of Access.  I used Access 2003.  Just open a copy of the MDW file from an account with admin security and select upgrade.  This will create a copy in the new version which 2013 will support

qfxfox

Yes, it turns out the MDW was the problem.  We have been using  Access for a long time with the built-in user accounts feature.  The security info is stored in an MDW file.  This file was in an old version that unfortunately Access 2013 cannot read.  Here are the steps to revert back to the default MDW that comes with Access:

1.  Press Ctrl-G as soon as Access starts which will bring you to the Visual Basic editor.

2.  Type --> docmd.RunCommand acCmdWorkgroupAdministrator

3.  Then specify the default MDW which is located at:  C:\Users\<YOUR NAME>\AppData\Roaming\Microsoft\Access\System.mdw

Next I upgraded the MDW file.  To do this you will need an older version of Access.  I used Access 2003.  Just open a copy of the MDW file from an account with admin security and select upgrade.  This will create a copy in the new version which 2013 will support