We have recently upgraded our desktop PCs to Windows 2000 (actually we cloned the PCs from images made from new Windows 2000 installations, not upgrades.) We are still running Office 97 applications. Since the operating system upgrade, we’ve had some users having problems with Access 97 databases and Excel 97 spreadsheets. An Access 97 user can no longer update her database (stored on network fileserver) using a database form. The database links to external Oracle tables, and the tables havebeen relinked using the latest Oracle ODBC driver. An Excel 97 user can not update a large Excel spreadsheet (also stored on the network.) Access rights on the server locations have been checked to be correct. The only new variable is the Windows2000 operating system on the PCs.
Does anyone know what causes this and how to fix it?