Make sure that the applications are split into front-ends (containing the
queries, forms, reports, macros and modules) and back-ends (containing the
tables). Leave the back-ends in Access 97, and convert copies of the
front-ends to Access 2003. Distribute the appropriate version of the
front-ends to each user. Once the last user has converted to Access 2003,
you can convert the back-ends if you want.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)