Toad Data Studio 1.0

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Troubleshoot Access Issues

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.

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.0 - User Guide

Troubleshoot Access Issues

Missing Functionality and Object Information

Other Issues