If he's running on a later version of Office and there is any code in the database, there will be some problems with library references. Also, any code that uses Recordsets will choke because Access 97 uses DAO (data access objects) where later versions can use DAO, but ADO (ActiveX Data Objects) is the default. Do this:
Open any module, then Tools > References. At the top of the list there may be one or more with Missing Uncheck these, scroll down the list to find the missing library / libraries, and click the check boxes ot select them.
Also select the latest DAO library you have, click OK, and then reopen the list. Using the arrows on the right of the window, push DAO above ADO. This makes it the default.
Now, in all modules, replace Recordset with DAO.Recordset, Database with DAO.Database, Tabledef with DAO.Tabledef, Querydef with DAO.Querydef, Parameter with DAO.Parameter.
Save and try it out.
Denis
