Office Access 97 convertion

R

Ray

Recently, I upgraded to Office Access 2003 and upgraded the existing
databases to work with Access 2003. Very strange that it was upgraded to
Access 2000 by default. I note that there is a tool to upgrade to 2002 &
2003. How can I change the default format to 2003 rather than 2000 and why
it is not upgraded to Access 2003 direct.

Thanks,

Ray
 
R

Rick Brandt

Ray said:
Recently, I upgraded to Office Access 2003 and upgraded the existing
databases to work with Access 2003. Very strange that it was
upgraded to Access 2000 by default. I note that there is a tool to
upgrade to 2002 & 2003. How can I change the default format to 2003
rather than 2000 and why it is not upgraded to Access 2003 direct.

Thanks,

Ray
Click to expand...

Because the default file format for NEW files in Access 2003 (and in Access
2002) is the Access 2000 file format. There's a place in options to change
that, but whether it affects the format for conversions from 97 I don't know.
 
D

Dirk Goldgar

Ray said:
Recently, I upgraded to Office Access 2003 and upgraded the existing
databases to work with Access 2003. Very strange that it was
upgraded to Access 2000 by default. I note that there is a tool to
upgrade to 2002 & 2003. How can I change the default format to 2003
rather than 2000 and why it is not upgraded to Access 2003 direct.
Click to expand...

Access 2003 uses the Access 2000 file format by default, for maximum
compatibilty with Access 2000 and 2002. There is an Access 2002-2003
file format, which can be used by both Access 2002 and 2003 (duh!), but
not by previous versions.

There's an option to set the default file format. I don't have A2003,
but in A2002 it's in Tools -> Options... -> Advanced tab, "Default File
Format". I don't know for sure that this will cause upgrades to be made
to that format, though; you'll have to try that out yourself, unless
someone else posts the information.
 
Top