Microsoft Access Tutorial - Convert Database to Different Version of Access
1. Open the Microsoft Access Database
Open the database you would like to convert. For this example, I will use the database that we have created in a previous tutorial but it really doesn't matter what Access database you use.
2. Click Tools -> Database Utilities -> Convert Database
If you click on the tools menu, you will see an option called "Database Utilities". Hover your mouse over this option and it will show you another option called "Convert Database". Once you move your mouse over this option, you will see you can convert to different versions of Microsoft Access. For this tutorial, select "To access 97 file format".
3. Name the Database
A window will open up called "Convert the Database Into". Give your database the name and select the location where were you would like to save your converted database. Once you are finished, click on save.
It will show you a warning window asking you if you are sure you want to do this conversion and that you won't be able to open the Access database with a different version of Access once you make the conversion. Make sure this is what you want to do and click Yes.
4. Open New Version of Database
To test this, you will need to open the database using the appropriate version of Microsoft Access. If you were to try to open that database with Microsoft access 97 it should open. If you try to open this database using Microsoft Access 2003, it will not open. It will make you go through a wizard to re-convert to the 2003 version before you can open it.
If you try to open an Access database using an incorrect version, a dialog window will open at the start asking you if you want to convert the database or if you want to just open the database and not make any changes. Often it's better to convert the database before you open because that way you can make changes to the tables in the database.
Instead of converting the database into a different version of Microsoft Access like in that example you can simply open the Access database with a different version of Access and it will ask you in a wizard if you want to convert it using the Wizard. You can click yes and the wizard will take it from there when it comes to converting your Microsoft Access database to the version of Access you are trying to use.
Published by Kantus
I love writing short stories and humor articles, but tend to stick with topics that are discoverable by search engines and capable of spreading virally. View profile
Top 10 Essential Freeware Replacements for Windows AppsDid you know you have a choice that isn't Microsoft for most desktop applications today? These applications are FREE for personal use and every application in this list is porta...- Microsoft Access Tutorial - 4 Steps to Creating a DatabaseA step by step guide to creating your first Microsoft Access database.
- Microsoft Access Tutorial - 5 Steps to Creating a Database TableA Step-by-Step guide to creating your first Microsoft Access database table.
- Microsoft Access - 4 Steps to Adding Data to a Database TableStep by Step guide to adding actual data into a Microsoft Access database table.
- All About the Reiser FS Hard Disk File SystemThere are many different hard disk file systems around these days. I will investigate the benefits of using the little known ReiserFS file system.
- OpenOffice: This Free Office Suite is the Best Alternative to Microsoft Office
- Free Computer Software that Delivers, Courtesy of Open Source
- How to Import Microsoft Excel Data Into Microsoft Access
- Comparison of Microsoft Office and OpenOffice
- The Best FREE Programs for Microsoft Windows
- Working with Access VBA
- How to Create a Database Using Microsoft Access