I have seen this before, and man was it trouble. We had Office 2k installed and needed Office97 to teach an Access 97 class. We found you cannot go backwards! If you must have both 97 and 2000 then try installing them on two separate machines. If this is not a possibility (must have both on the same machine) then try convincing that person that a second PC would be a lot easier.
If you still must have both on the same machine, I would remove both Office 97 and Office 2000 Access and all from the machine and then make sure you have at least two partitions on your hard drive. Then install 2000 on the C drive and 97 on the D drive. Before installing 97 on the D drive, make sure that the 2000 works on the C drive (is should). Sometimes the registry does not get all of the junk cleaned and the problem will remain. Go ahead and install 97 on the D drive.
If you get the same error with only 97 on the D drive, you have nasty registry problems. Then a registry fixer (careful,this can be dangerous) or a complete Format and reinstall of WinME will be needed. Although, removing and reinstalling both 97 and 2000 on separate partitions should fix it.
Another labor intensive but guaranteed way of doing it (but is not really necessary) is to create 2 partitions as above and do a dual boot. If you have a need for two operating systems but only one box, this could be a double fix. (i.e. run WinME and Win2000 Professional on the same box. I do this and it works great. (read up on it first)
Out of curiosity, why will the db not work in 2000? What type of errors are you experiencing when you convert it.
Good Luck