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
  • 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?
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.


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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Macro 6 50
linked subforms are yielding error:  ... (800110108) 3 15
Search Form not Querying 2 10
Input Data Using a unique ID from another sheet in Excel 3 5
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now