Access 2003

[Roger]

A simple question for most! Will a Data Base created in
Access 2003 work in Office 2000 without any hitches?

Thanks for any help here

Roger

 

[Douglas J. Steele]

It depends. Access 2003 can save databases in one of two formats: Access
2000 or Access 2002/2003 format. In order to be able to use it in Access
2000, it must be stored in Access 2000 format.

As well, you cannot use any features that exist in Access 2003 but not in
Access 2000.

Other than that, it should work all right.

 

[Guest]

Excuse me for butting in on Roger's question, I direct this to Douglas
Steele. When you say Access 2003 can save databases in Access 2000 format,
can you please specifiy how to do this? I have Access 2000 .mdb files which
ran fine in Access 2002. I was able to make changes and recompile as 2000
format. But I can't do this in 2003. I can't find the option to recompile as
Access 2000 format, and when I try to compile (in VB editor) it keeps telling
me the reference libraries are missing, and I don't have a way to reference
them (Object 9.0 files). Obviously the 2000 reference library files won't
exist in 2003 so I don't understand how the recompilation to 2000 format is
accomplished, or what I need to do differently in 2003 than in 2002. Thanks
much. jlsunny

 

[Douglas J. Steele]

Tools | Database Utilities | Convert (or something like that)

You're not compiling it as Access 2000: you're converting it to Access 2000.