Review the following solutions to help troubleshoot Access issues pertaining to missing functionality and object information and other problems in Toad.
See Create Access Connections for more information about Access connections.
Issue | Cause/Solution |
---|---|
Some queries display in the View tab of the Object Explorer, but do not display in the Query tab. |
The Access ODBC driver handles saved queries in the following manner:
|
Primary key information is unavailable. |
The Microsoft Access ODBC driver does not return primary key information for databases. However, in some cases, Toad can obtain this information through additional methods. |
Issue | Cause/Solution |
---|---|
A delay occurs between writing a value to a database via one connection and seeing the updated value via another connection. |
This delay is the default when you are writing and reading data between two different Jet connections. The delay occurs even if the two connections reside in the same client process. Solution: Use a single connection when updating data. |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center