The default file format for Access 2003 is actually the Access 2000 format.
Unless you're using features that are only available in Access 2003, there
should be no problems working with your databases in both Access 2000 and
Unfortunately, the same isn't true with your Access 97 databases. If you're
going to have people continuing to use Access 97 for some time, you should
split all of the Access 97 databases into a front-end containing the
queries, forms, reports, macros and modules and a back-end containing the
tables. The back-end should be left in Access 97. A copy of the front-end
should be opened in Access 2003 and converted for those people using Access
2003 (or 2000). Any changes to the front-end should be made in Access 97 and
then the copy reconverted.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Graeme Stickings" <Graeme XXXX@XXXXX.COM > wrote in