Here is a workaround I use.
To begin you may need to use this command line. to use it go to Start-Run aNd type it in quotes and all
?C:\Program Files\Microsoft Office 2000\Office\msaccess.exe? /wrkgrp ?C?\Program Files\YOUR-DATABASE DIRECTORY\system.mdw?
If you are using Access 2000, then you need to create a new database, link to the existing database tables, and import the existing database queries. To do this, after you start Access 2000 with the above command line, elect to create a new blank database. Give the database a name such as YOUR-DATABASE2000.mdb and elect to save it in c:\program files\YOUR-DATABASE-DIRECTORY. Then do a File, Get External Data, Link Tables, select the YOUR-DATABASE.mdb file, Select All Tables and then click OK. Then do a File, Get External Data, Import, select the YOUR-DATABASE.mdb file, click the Queries tab, Select All, then click OK. Your YOUR-DATABASE2200.mdb Access 2000 database will then have all the queries as the YOUR-DATABASE Access 97 database and will be linked to all of the original tables.
If using Access 2000, your data is stored in the original tables but your objects such as queries and reports, are stored in the new Access 2000 database. If you want a query to also be available in 97 version, you can copy the query SQL to the clipboard, shift to THE 97 VERSION, add a new query, edit it, then paste in the new SQL. School Maestro does not use Access reports. If you create a report using the Access report generator,you must use Access to run the report.
HOPE THIS HELPS.
CARL mARTIKEAN
