Background

Total Access Detective finds the differences between any two objects in one Microsoft Access database, including fields, controls, properties, macro lines, module code, and data.

Problem

"Not a valid bookmark" error message while running the database object compare with Total Access Detective.

We have received reports of Total Access Detective crashing with this error while performing a database object comparison.

Error Description: Not a valid bookmark.
Error Number: 3159
Procedure: PopulateInventoryRelations
Error Line: 4150

Cause

Corruption in the database relationships.

Solution

To see if this is a problem, add this Access VBA procedure to your database and run it:

Sub TestRelations()
  Dim rel As Relation
  Dim dbs As DAO.Database
  
  Set dbs = CurrentDb
  For Each rel In dbs.Relations
    Debug.Print rel.Name
  Next rel
End Sub

This procedure goes through the database relationships and lists them in the Immediate Window. If it encounters a corrupt relationship, it will crash so you can see which one it is.

Before doing anything, make sure you have a backup of your database.

Decompile

Decompile your database to see if that solves the problem. Many odd VBA and object related issues are cleaned up when the database is decompiled. Read our paper for details: Decompile Your Microsoft Access Database to Improve Performance, Fix Corruption, and Avoid Strange VBA Errors

Then perform a repair and compact of your database application.

Finally, run the TestRelations procedure again to see if problems remain.

We recommend creating backups of your database on a regular basis to minimize the impact of disasters.

Additional Support Resources

Articles in this section

"Not a valid bookmark" error message while running the database object compare with Total Access Detective