With Total Access Analyzer 97 the error that you are receiving may be caused by one of the following issues:
Code in a module or a macro is pointing to a report that is not there. This implies that there is a broken VBA reference in code somewhere in your database. To resolve this problem, follow the steps to decompile and recompile your database, and run Total Access Analyzer again.
There is a space in the Hyperlink property of the properties of a control. To resolve this problem:
- Open the form or report with the name of the one in the Error log.
- Go to each control (most likely a Label control) to determine the properties of them and find one with a space (" ") in the Hyperlink or Hyperlink SubAddress property.
- Remove the space in that field.
- Compile and save all modules, and run Total Access Analyzer again.
This may be due to a bug in MS Access regarding checking attributes of a Crosstab query. When checking the attributes of a field in a Crosstab query, MS Access tries to actually run code that the data source uses to get its data when the data source is another query! Unfortunately, this is a bug in MS Access 97 and 2000.
This is a Microsoft bug that has been reported to Microsoft. In the meantime, the only available workaround is to not analyze the Crosstab queries that have relations to any query that uses the query "SelectQuery1". We highly recommend that you inform Microsoft of this issue as well, so that they are aware of the number of customers affected by this bug.