Microsoft Access Database Versions

K

Kate

I would like to open a database developed using Microsoft Access 2003 with an
older version of Access 2000.
 
B

Brendan Reynolds

By default, Access 2003 and Access 2002 use the same file format as Access
2000. There is, however, an optional new Access 2003/2002 format. If the
database is in that new format, you can not open it in an earlier version of
Access, but the person who created it can use Access 2003 to convert it to
the earlier format for you. Of course, any new features that were not
supported in the earlier format will no longer work.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
J

John Vinson

I would like to open a database developed using Microsoft Access 2003 with an
older version of Access 2000.

You can open the database in 2003, and use Tools... Database
Utilities... Convert Database... Convert to Access 2000 version.

You'll lose any features which exist in 2003 but not in 2000.

You may want to just try opening it first; by default, A2003 creates
databases in 2000 format!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top