diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Troubleshooting: Microsoft Access 2010 adds “MsysResources Table” issue

You’ve a Microsoft Access ACCDB database (from Access 2007 or 2010) and want to save it to a Access MDB format database so it can be used by Access 2003 or earlier. Unfortunately, when you try this in Access 2007, an error message pops-up:

“This could occur if you added new ACCDB features of Access 2007/2010. Or, if the database was opened with Access 2010, which stores themes in an attachment field in MsysResources table, and MDBs don’t support attachment field types. So even though you didn’t add this incompatible field type to your Access database, Access sees this table and field and and concludes the database can’t be converted,” explains Microsoft.

To resolve:

  1. In Access 2007, right-click top bar of Navigation Pane, then click Navigation Options
  2. Then under Display Options, select Show Hidden Objects and Show System Objects check boxes, then click OK
  3. Select MsysResources table, press DELETE
  4. Save ACCDB as an MDB. Thats’s It!.


Share This Story, Choose Your Platform!