Opening Access 2007 file in earlier version

  • Thread starter Thread starter jewels
  • Start date Start date
J

jewels

I have a file that I need to open. It was sent as an Access 2007 database but
I have Access 2003.
 
New opens old, but old doesn't understand new.

You need to have whoever sent you that Access 2007 database re-save it as
Access 2003, then re-send.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a file that I need to open. It was sent as an Access 2007 database but
I have Access 2003.
Click to expand...

When Access 2003 was written, the programmers did not know the format of 2007
databases; therefore they did not include 2007 compatibility in their design.

You will need to get the sender to save the database in 2003 format, or get
someone who has 2007 to do so for you. Some new features (e.g. the ribbon)
will not be available, and if it's an .accdb file it must be converted to a
..mdb.
 
I have a file that I need to open. It was sent as an Access 2007 databasebut
I have Access 2003.
Click to expand...

Hi,

Use Access 2007 Runtime to RUN such DB. For modification of DB (if
none of the new objects - Access 2007 specific was not in use), see
Jeff Boyce advice.

Regards,
Branislav Mihaljev
Microsoft Access MVP
 
Hi,

Use Access 2007 Runtime to RUN such DB. For modification of DB (if
none of the new objects - Access 2007 specific was not in use), see
Jeff Boyce advice.

Regards,
Branislav Mihaljev
Microsoft Access MVP
Click to expand...

How do I do that?
 
I ran that and it downloaded the run program but I can' figure out how to
open the file. When I click on the file it asks me to find a program to open
it with. Very confusing.
 
I ran that and it downloaded the run program but I can' figure out how to
open the file. When I click on the file it asks me to find a program to open
it with. Very confusing.
 
I ran that and it downloaded the run program but I can' figure out how to
open the file. When I click on the file it asks me to find a program to open
it with. Very confusing.
Click to expand...

Hi,

It is runtime - just run DB instead program and it will load runtime
and load DB. That in case if file association of your Windows system
are OK, that is, when you double click ACCDB Windows know it is
associated with your (newly installed) runtime of Access 2007, and it
will run it with parameter of database name. If it does not work as
intended (when you double click ACCDB it ask for parameter), then
there is something wrong with file type ACCDB association.

Regards,
Branislav Mihaljev
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Will 2003 database be compatible with Access 2007 4
Cannot open ACCDE file - receive "database is in unrecognized form 0
Access 2007 opening older versions of Access databases 3
error when opening .accdb file 6
Open a Access 2003 file in Access 2007 version 2
Opening Access Database from Internet Explorer 2
Access 97 Installed with 2007 Runtime 3
Read Data from Excel 2007 1

Back
Top