Using different versions of access

[ken]

I just opened up an access database that works both in 2k3 and 2k. How
is this possible? Usually access would pop up with a window that says
you have to convert this database to the latest version. Otherwise you
can only view it read only..

?

Thanks

[Larry Linson]

"ken" <ge****@gmail.com> wrote

I just opened up an access database
that works both in 2k3 and 2k. How
is this possible?

Access 2002 and Access 2003 can use databases either in Access 2000 file
format or in Access 2002/2003 file format. In fact, the default is that the
file will be saved in Access 2000 file format. You can use Tools | Options
to save in Access 2002/2003 file format, if you want new features. You are
correct that this is different than earlier versions of the product.

One new feature that I especially like is that DoCmd.OpenReport now provides
an OpenArgs argument and Reports have an OpenArgs property from which you
can retrieve the value entered in the OpenArgs argument. You can pass
criteria or other information, and apply it to the Report.

The "how" is that this is the way Microsoft implemented these versions of
Access. You cannot use new features introduced with Access 2002 or 2003 if
you save and use the Access 2000 file format.

Larry Linson
Microsoft Access MVP

[ken]

Thanks Larry for this answer and all your previous answers to my
questions.