Opening Access 2007 databases in Access 2003.

[Guest]

Is it possible to open Access 2007 databases in Access 2003? A friend mine
told me he tried to open a .accdb file in Access 2003 and got a
unrecognizable format error. I imagine you can open 2003 databases in Access
2007.

 

[Scott McDaniel]

Is it possible to open Access 2007 databases in Access 2003? A friend mine
told me he tried to open a .accdb file in Access 2003 and got a
unrecognizable format error. I imagine you can open 2003 databases in Access
2007.

2003 cannot open 2007 database saved in the new ACCDB format. 2007 can save databases in the older 2000/2003 format,
however, in which case your friend could open them in his Access 2003 program.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Aaron Kempf]

yes; Office 2003 will get a SP3 that will enable this; in addition to SQL
Server 2005 support

 

[John W. Vinson]

Is it possible to open Access 2007 databases in Access 2003?

No.

The .accdb format didn't even EXIST when 2003 was written, and the programmers
did not have a time machine handy to read the specs.

Later versions can open earlier versions, though.

John W. Vinson [MVP]