[dba-SQLServer]Migrating from SQL7 to SQL2000

I will be migrating from SQL7 to SQL2000 in the next month or so.  Need
advice - what will be my major problems?  In addition, our company has many
Access 97 databases that are linking and updating (augugughghghg!!!!) to
SQL7.  I am working through those folks to get them into Crystal interfaces
and running stored procedures to update their data, but am concerned about
the compatability if I do not catch all the apps before I migrate.  I
already have contacted those using JAVA to let them know to gear up.

All advice is appreciated.

Thank you.