Toad Data Studio 1.1 - Release Notes

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

Features New Features System Requirements Resolved Issues and Enhancements Known Issues Third Party Known Issues Getting Started Product Licensing Globalization About Us Copyright

Troubleshoot Access Issues

Review the following solutions to help troubleshoot Access issues pertaining to missing functionality and object information and other problems in Toad.

Create Access Connections about Access connections.

Missing Functionality and Object Information

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: If the stored query does not contain parameters, it is treated as a view and displays in the View tab. If the stored query contains parameters, it is treated as a stored procedure and displays in the Query tab.
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

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:

If the stored query does not contain parameters, it is treated as a view and displays in the View tab.
If the stored query contains parameters, it is treated as a stored procedure and displays in the Query tab.

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.

Other Issues

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.

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.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Toad Data Studio 1.1 - Release Notes

Troubleshoot Access Issues

Missing Functionality and Object Information

Other Issues