ConsciousVibes.com

Home | Links ( Motorcycles, Computers )

Microsoft Access Tips

All of the information, instructions, and recommendations on this Web site are offered on a strictly "as is" basis. Remember "Murphy's Law." Please take the proper precautions before attempting any of the tips or modifications listed here.

Contents

How to convert a Microsoft Access .mdb to .accdb

To convert an Access .mdb to .accdb

1. Open the Microsoft Access .mdb file you want to convert
2. Go to: File > Save & Publish
3. File Types: Save Database As
4. Save Database As: Access Database (*.accdb)
5. Click the "Save As" button

You should then see the "This Database has been upgraded to the Access 2007 File Format."

If you get a "file already in use" error after clicking the "Save As" button,

Then follow these steps:

1. Open Microsoft Access 2010
2. File > Open
3. Navigate to the .mdb file you want to convert
4. Click once on the file so that its name appears in the "File name:" field.
5. While holding the <Shift> key, click on the Open button.
6. Go to: File > Save & Publish
7. File Types: Save Database As
8. Save Database As: Access Database (*.accdb)
9. Click the "Save As" button

The Wizard is Unable to Create Your Report

Symptoms

• When you attempt to use the Report Creation Wizard you receive the following error: "The wizard is unable to create your report."
• When you attempt to modify or preview an existing report, nothing happens, and no error message is displayed.

Cause

Resolution

• Set any local printer that uses the LPT1: port as your default printer.