Share via

Importing MDB files in Access 2016

Anonymous
2016-05-25T17:19:50+00:00

I am working with an Access Application created using Access 2000 that has worked fine with Access 2007 and Access 2010.  Access 2016 will open the application but will not allow the importing of mdb files giving the error message that it will not import files created in a previous version of Access.  I am also unable to convert the files from an mdb format because Access won't open them.  Would appreciate any suggestions.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,531 Reputation points Volunteer Moderator
    2016-05-25T17:37:03+00:00

    Hi. How about rather than opening the MDB file and then try to import other MDB files into it, can you create a brand new "blank" database in Access 2016 and then import all the objects from the MDB file? Then, you can try to import the other MDB files into it. Just a thought...

    2 people found this answer helpful.
    0 comments
  2. ScottGem 68,775 Reputation points Volunteer Moderator
    2016-05-25T17:54:23+00:00

    Do you still have a version of 2007 or 2010? Full support for mdb files was removed with 2016. So you have to convert your mdbs to accdb to continue to use them under 2016.

    Correction: The issue is with files originally created with Access 97. MDBs created in later versions will work.

    However, I would still be working at moving all my MDBs to ACCDB.

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-05-25T18:08:39+00:00

    Tried you suggestion...........everything imported fine but it won't show me the user friendly oblect....just the code.

    0 comments
  4. Anonymous
    2016-05-25T18:09:59+00:00

    No I sure don't....................tried to convert to accdb and was able to do that with the application but can't open the mdb data I want to import so I'm unable to convert them.

    0 comments
  5. DBG 11,531 Reputation points Volunteer Moderator
    2016-05-25T18:12:46+00:00

    Hi. I don't have a copy of 2016 but if you're saying you can't get the data, does it mean you can't even "link" to the MDB table? Bummer. If you want, I am still using 2010, you can send me a copy of your MDB, and I'll convert it to ACCDB for you. Just a thought...

    0 comments