I successfully installed Access 97 AFTER a full install of Office 2000. I simply created a separate Access 97 directory at the root level of the Programs directory. You could also do it at the root level of your hard drive. Anyway, the important thing is that it should not be within the Office directory. When your Access 97 installer asks where you wish it to be installed, point it to your new special directory. I have had both 97 and 2000 coexisting for a month or so and use them separately asrequired. No problems so far.
You may run into problems if you are trying to install Access 97 from an Office 97 package. I have the Access 97 install disk as a separate entity. Perhaps the Office 97 installer will try to play games that the individual application installer will not.