transferring database into
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Transferring a 2003 database into 2007 version.

Transferring a 2003 database into 2007 version.

The UK's most regular instructor-led training courses.
Training information: 'ms access+course' · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

resolvedResolved · Low Priority · Version 2007

Transferring a 2003 database into 2007 version.

Kelly has attended:
Access Intermediate course

by - delegate Kelly [2 posts] (2008 Jun 25 Wed, 10:08) replyReply

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.

Access VBA 2 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003 2008 Dec 4 Thu + 5 Fri Southwark 7 book now £345 £399
2003 2009 Jan 8 Thu + 9 Fri Southwark 7 book now £345 £399
2003 2009 Feb 5 Thu + 6 Fri Southwark 8 book now £275 £399
2003 2009 Mar 5 Thu + 6 Fri Southwark 7 book now £345 £399
2003 2009 Apr 8 Wed + 9 Thu Southwark 8 book now £275 £399
2003 2009 May 7 Thu + 8 Fri Southwark 8 book now £275 £399
Full Schedule: See all 12 Access VBA course dates.
Bookings currently available until 5th November 2009.

RE: transferring a 2003 database into 2007 version.

by - trainer Pete platinum contributer[799 posts] (2008 Jul 14 Mon, 09:28) replyReply

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


Related articles

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access, an Efficient Database Tool
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Why go on a Microsoft Access Training Course?
· Microsoft Access Tighten your Security Controls

Please browse our web site to find out more about
'ms access+course' and other Microsoft training courses.

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information

Training Articles

AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz