Can you open a database created in Access 2007 using Access 2003?

Posted on 2008-06-20
Last Modified: 2013-11-29
Hi Experts,

I created a database using Microsoft Access 2007, and put it on a computer that uses Microsoft Access 2003.  I can't get the database to open properly using 2003.  Any ideas?  Thanks.

Question by:linbayzak
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 92

Accepted Solution

Patrick Matthews earned 500 total points
ID: 21834871

MS has published a compatibility pack that allows you to open Excel, PP, and Word 2007 files in Office 2003,
but AFAIK no such option exists yet for Access.


Author Closing Comment

ID: 31469323
Oh, that's really bad, this db is for a client and they are kind of in a hurry.  Ok, thanks for the heads up.  Have a nice evening :-)

LVL 92

Expert Comment

by:Patrick Matthews
ID: 21834931
Glad to help.  Can you have someone with 2007 try to save it down to 2003 or 2000?
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Author Comment

ID: 21834998
How, I have 2007?
LVL 92

Expert Comment

by:Patrick Matthews
ID: 21835247
I am stuck on Office 2003, so I am not sure.
LVL 19

Expert Comment

ID: 21835573
What I would try to do is create a blank 2000-2003 database (*.mdb) and then attempt to import all your objects from the 2007 database into the 2003 version.

Good Luck.

Dawn Crosier-Bleuel
Word MVP

Author Comment

ID: 21836051
Thanks, it is worth a try, I worked a long time on it.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question