RESOLUTION
To resolve this problem, obtain the Microsoft Office 2000 Developer Service Release 1 (MOD SR-1) Fulfillment CD.

NOTE : You cannot correct this problem by downloading and installing the MOD SR-1 Update because it does not include the Access Run-Time SR-1 files.

For additional information about how to obtain the Microsoft Office 2000 Developer Service Release 1 (MOD SR-1) Fulfillment CD, click the article number below to view the article in the Microsoft Knowledge Base:

Q253566 MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)
To work around this behavior, make sure that you either avoid clicking the Customize button, or, if you do, make sure to set the path for the installation location to a folder that does not contain another version of Access.

If Access 97 has been overwritten by the Access 2000 Run-Time component, you must remove the Access 2000 run-time application, and then reinstall Access 97.

To repair the installation of Access 97, please see the following article in the Microsoft Knowledge Base:
Q235280 ACC2000: "Can't Find the Database You Specified" Error When Starting Access 97 After Upgrade to Office 2000

MY SUGGESTION:
I would removed any Access 97/2000 you might have from your computer and freashly install Access XP. OR, I would install Access 97 in a completely different directory.