Toad Data Studio 1.0

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

Welcome to Toad Data Studio Understand Toad's Workflow

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.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Toad Data Studio 1.0 - User Guide

Troubleshoot Access Issues

Missing Functionality and Object Information

Other Issues