Does anyone know how to convert mdb to accdb?

I have an old database created with Access 97 (I think) and I want to convert it to accdb.

Before having an interview the employer wanted me to do a few exercises using Access and a site in PHP so we will discuss about it during the interview.

Here’s the database file:
https://drive.google.com/open?id=1ubX-0efkPrukTbPDpcVBJPMZYXfAAqez

I don’t really know, I tried with 2000 format but it didn’t work.
Will it require me to replace the version of access to 2003 or just setting it to 2003 it’s fine?
I can’t do that, do you have any tip or guide on how to do that?
I am afraid it will take me a lot of time to find a way to convert it. :pensive::pensive:
I don’t know if they’ll take notice on how much time it passed after they sent me the exercises.

why not just ask them for software access ? I’m sure many people don’t have access on their home machines…

Access 2016

That what the employer wrote me in the email:

The first exercise is about .NET and you can pick whatever programming language you want (attached you can find the ‘exercise_.net.txt’ and an Access database ‘Nwind.zip’).
The second one is about PHP.

I need it to do the exercise, I have to create a form (and also follow other instructions) and then also all the queries that he listed in exercise_net.txt.

You can write your own logic using npm mdb parser to read the old mdb access file and convert to whatever format you want.

npm install mdb-parse
var Mdb = require(‘mdb-parse’); var f = new Mdb(’./desktop/Nwind.mdb’);

var was not recognized as a command…

try installing mdbtools first. read more here.
that parser depends on mdbtools. or just try to find other npm package that works with old mdb files

Do I also need to install all the requirements? http://mdbtools.sourceforge.net/install/c98.htm#REQTABLE

Use https://www.rebasedata.com/ I convert the .mdb file successfully. nut not accdb

I didn’t understand your instructions.

Convert Microsoft Access MDB to CSV
Convert Microsoft Access MDB to Excel
Convert Microsoft Access MDB to XLSX
Convert Microsoft Access MDB to MySQL
Convert Microsoft Access MDB to SQLite

no mdb to accdb

I tried with this to installed mdbtools:

cvs -d:pserver:anonymous@mdbtools.cvs.sourceforge.net:/cvsroot/mdbtools login
cvs -z3 -d:pserver:anonymous@mdbtools.cvs.sourceforge.net:/cvsroot/mdbtools co mdbtools

but it doesn’t recognize it, I am using git as cmd.

Unfortunately i failed also in installing mdbtools on my win machine. as far as i have read it was not tested on windows or mac just linux.

Maybe you should test using odbc with some npm parser.
Anyway, if i find some decent solution i will let you know.

1 Like

To convert Access Database from Mdb to Accdb file format , kindly follow the methods given below:

  • At first go to MS Access Database
  • Open the new Database File
  • Create your file
  • Now in the file Types , select the option Save Database As and click Access Database (*.accdb)
  • A dialogue box will open
  • Choose the file which you want to convert
  • Lastly, click the Save As option to make the changes