Kelly has attended:
Access Intermediate course
Transferring a 2003 database into 2007 version.
I open up access 2007 from the desktop and find the database that i want to use, which was originally set up years ago by my pre-decessor on access 2003.
When i open it the security warning bar pops up with the options button, i press this and choose 'enable this content' and press 'ok'.
When the database opens it is still the 2003 version, is there any way i can transfer it into a 2007 version (without starting again), so that the database still has all the exact information that has previously been entered?
I have had a look all through the different buttons/options when i open it up but i cannot see anywhere where it say's about doing this.
Many thanks for your help.
RE: transferring a 2003 database into 2007 version.
Hi Kelly
Thank you for your post, in response:
To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the Access 2007 file format (.accdb), you must first open the database in Access 2007 and then save it in the .accdb file format.
Click the Microsoft Office Button, and then click Open.
In the Open dialog box, select and open the database that you want to convert.
Note: If the Database Enhancement dialog box appears, the database is using a file format that is earlier than Access 2000.
Click the Microsoft Office Button , point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.
If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.
In the Save As dialog box, type a file name in the File name box, and then click Save.
Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.
I hope that has helped. Regards Pete
