98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Transferring a 2003 database into 2007 version. | Access forum
Transferring a 2003 database into 2007 version. | Access forum
Resolved · Low Priority · Version 2007
Wed 25 Jun 2008, 10:08Delegate Kelly said...
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.
Mon 14 Jul 2008, 09:28Trainer Pete said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
