Access 2003 --> 2002 compatibility

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I'm developing a simple database application in Access 2003. While I
recognize that I can't run Access 2003 on a Windows 98 machine, can my
Access 2003 .mdb file be opened in Access 2002? Will I lose any
functionality? My app includes the usual assortment of tables, forms and
queries which I assume are portable back to Access 2002, but what about my
VBA code?

Thanks for any help or links on this topic!
Ken
 
Ken said:
I'm developing a simple database application in Access 2003. While I
recognize that I can't run Access 2003 on a Windows 98 machine, can my
Access 2003 .mdb file be opened in Access 2002? Will I lose any
functionality? My app includes the usual assortment of tables, forms and
queries which I assume are portable back to Access 2002, but what about my
VBA code?
Click to expand...

Actually both Access 2002 and Access 2003 still use the Access 2000 file
format by default. So as long as you didn't explicitly change your file to
the newer file format you should be able to open it with anything from
A2000 to A2003.

Now...if you used any of the new functionality only available in A2003,
then those features obviously will fail when the file is opened from an
older version. Otherwise you should be fine.
 
Rick,

Thanks, that's what I needed to know. I don't *think* I've used any of the
2003 only functionality, but a little testing in 2002 should answer that
question.

Thanks again,
Ken
 
Back
Top