I'm afraid there is no default way to configure where this module installs access to. Don't the files get copied to [ProgramFilesFolder]Microsoft Office\Access 97?
What do you mean by "I added the module to the msi with Developer by opening the msi and editing it."? The module will be merged in to your setup only if you open Develeloper, go to the Merge Modules view, Select Access97 Merge module and then build the project.