Mike,
I've migrated a couple of A97 databases to XP. The main issue is to set a reference to DAO 3.6, and then explicitly reference DAO in all your Recordset code. After that, the project should compile.
Watch out for the Hattenschweiler font issue that I mentioned earlier -- gets around an error that "You don't have a license for Access" when you try to open A97 in a mixed environment. Check the KB for more details.
Denis