Converting database to accdb RRS feed

  • Question

  • Years ago I split my database into database forms, reports, querries, etc, and the actual data table. This was convenient at that time for database bloat and transportation on a floppy disk (like I said: years ago). This is probably no longer necessary, but 1) I have no idea how to combine the two files and 2) if it ain't broke, don't fix it.

    I am now using Office 2016 and have saved the database as an accbd file.

    The table with the data did not convert, it is still an mdb file.

    If I double click on the data.mbd file, Access uses it's smarts to open te old Camp.mbd file (still in the directory, just in case I need to "go back". So how do I get only the table with the data to open, and can I save that as an accdb file. Perhaps more importantly: should I?


    Thursday, March 21, 2019 11:30 AM

All replies

  • 2) works

    peter n roth -, Maybe some useful stuff

    Friday, March 22, 2019 2:27 PM
  • Simplest way is to make a copy of your front end and remove the linked tables. Then import the tables from your back end instead of linking them. That will automatically convert the table structures to the newer accdb format.

    If you want to keep the setup split create a new, blank accdb file and import the tables from the .mdb file. Again, that will convert them to the newer format. From there, you can open your front end and change the links to the new accdb back end using the linked table manager and checking the box for "Always prompt for a new location".

    Bill Mosca

    Friday, March 22, 2019 7:00 PM