Opening Access 2007 databases in Access 2003.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 30 Apr 2007 20:22 GMT

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.

Reply to this Message

Scott McDaniel - 30 Apr 2007 20:33 GMT

>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

Reply to this Message

Aaron Kempf - 30 Apr 2007 20:37 GMT

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

> 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.

Reply to this Message

John W. Vinson - 30 Apr 2007 21:03 GMT

>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]

Reply to this Message