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.
Are you sure it is an Access 2000 format? If it is an Access 97 format, then you will first have to open it in Access 2003 and then save it, so that you can convert the Access 2003 version to Access 2013 or 2016.
Why not just practice the exercises using a 2013 or 2016 accdb file?
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.
I don’t know if they’ll take notice on how much time it passed after they sent me the exercises.
So they sent you an Access db file that is from 2000 or before that you are supposed to use for these exercises? I am confused why they would do that. I would think the exercises would be generic enough that you could use any version of Access you want.
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.
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