Help Desk: How do I correct the problem compacting or upgrading my database related to Error #3197?

The cause of the problem is that your database has become corrupted and  it will no longer compact and you cannot import it into the new release. See URL: http://support.microsoft.com/support/kb/articles/q182/8/67.asp The article says this can happen if your system crashed during a database write operation. This could happen due to a power hit or a system reset.

Microsoft provides a new compact and repair utility to correct the problem.

See URL: http://support.microsoft.com/support/kb/articles/Q172/7/33.asp

The improved database compact and repair utility is included with Release 1.15 and later. Use the following procedure to repair your database:

1. Run the new short cut: Repair Your Database
2. Then select the file to compact: Laser Disc Register.mde
3. Then using tools command set the system database to: laser.mdw
4. Then using tools set the user to: laseruse    There is no password for laseruse
5. Then set the file to compact to: temp.mdb
6. Then run the compact command button. After the compact completes:
7. Rename Laser Disc Register.mde to Copy of Laser Disc Register.mde
8. Rename temp.mdb to Laser Disc Register.mde