Sql on Windows 2000

If the query is written correctly using the correct sql standards then it should work on both, (make sure you are using the most recent service pack for Access 97 and the most recent Mdac_Typ32 - if you use DAO then for the Mdac use 2.5, otherwise for ADO use the most recent version. There were a few problems with filters and wildcards with other versions.
Please post a comment to your question (not to my answer) and show the sql statement in question (either your code or if the query was donein the query builder then go to VIEWS|SQL and copy the Sql statement), and also inform us as to just what isn't working (errors, or it just doesn't return any records, or whatever. Also, is the database local or on a server?).