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.
"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
Corruption in the database relationships.
To see if this is a problem, add this Access VBA procedure to your database and run it:
Dim rel As Relation Dim dbs As DAO.Database Set dbs = CurrentDb For Each rel In dbs.Relations Debug.Print rel.Name Next rel
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 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.