Opening Access 2007 file in earlier version

[jewels]

I have a file that I need to open. It was sent as an Access 2007 database but
I have Access 2003.

 

[Jeff Boyce]

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

 

[John W. Vinson]

I have a file that I need to open. It was sent as an Access 2007 database but
I have Access 2003.

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.

 

[[MVP]]

I have a file that I need to open. It was sent as an Access 2007 databasebut
I have Access 2003.

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

 

[jewels]

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

How do I do that?

 

[[MVP]]

How do I do that?

Hi,

Download and install Access 2007 Runtime from
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

It will allow you load and run ACCDB, but will not allow you make
design changes.

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[jewels]

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.

 

[jewels]

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.

 

[[MVP]]

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.

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