Hi Bob
As an learner, you have me puzzled when you say create a new blank ACCDB file and then import everything from the old file. The database I have in Access 2000 has lots of fields, am I to understand that I need to create all the same fields in a new Access 2007 database and then go back to the Access 2000 database and then import that into the newly created database? Thanks for your speedy response by the way, I am impressed, regards, Mike
No, you don't have to recreate anything. Okay, to create a new, blank ACCDB file you just:
1. Open Access
2. Click on BLANK Database (see screenshot below)
3. Then name the file in the area that will come up on the right side of your screen.
4. Then Click on the EXTERNAL DATA tab.
5. Select ACCESS from the IMPORT tab.
6. A dialog will come up where you can go browse to your current database (the 2000 version file) and the option on that dialog will say IMPORT TABLES, QUERIES, FORMS, REPORTS...etc.
7. Once you've browsed to your file and click OK another dialog will come up with each object in Access on a tab for each type. You will start on the TABLES tab. Click the SELECT ALL button and then click on the QUERIES tab and select all, and then the FORMS tab, and so on.
8. Make sure to click the OPTIONS button on the right side of that dialog as well and check the boxes for RELATIONSHIPS, TOOL/MENU BARS (if you have any custom ones in your 2000 file), and IMPORT/EXPORT SPECS if you have any of those in your 2000 file.
9. When all have been selected, click OK and everything will import into your new file.
Hope that helps.
(SCREENSHOT OF WHERE TO CREATE BLANK DATABASE):