actually we got some applications that works propertly in access XP, and also some users working with access 97. the 97 users wants to link the access XP tables, but we don't know how could it be, because we're getting some fatal errors!!! i think it's something about Jet Drivers!!!
Can't help you with the exact solution, but your intuition about jet drivers is right I guess.
I've seen an app from Access 97 linking to A2000 tables through ODBC drivers. So I guess you will have to set up the Data Access parts of Office XP on your Office 97 machines.
But,... I would not know the details how to do so. Will have to do with ADO en DAO things.