AccXP / Acc97 passthrough to SQL Server backend - documentation?

Ron_A

NewBee, Got some clues from some databases written using passthrough
queries but don't understanc the case... statements. Is there any
books anywhere that wiill include help on the syntax required for
passthrough queries? Would I look for TSQL manuals???

Nov 13 '05 #1

Subscribe Post Reply

1412

Tom van Stiphout

On 14 Oct 2004 05:55:21 -0700, ro**********@excite.com (Ron_A) wrote:

Passthru means that Access doesn't interpret the code, but sends it
off to the server unchanged for processing. Therefore you would need
the documentation of the server. If it's SQL Server, the language is
T-SQL, which is documented in SQL Server Books Online, a help file
that comes with SQL Server. Ask your administrator for the "client
tools" (on the SQL Server disk) which I believe installs Books Online,
as well as several other tools to test your T-SQL script.

-Tom.

NewBee, Got some clues from some databases written using passthrough
queries but don't understanc the case... statements. Is there any
books anywhere that wiill include help on the syntax required for
passthrough queries? Would I look for TSQL manuals???

Nov 13 '05 #2

by: Baz'noid | last post by:

Hi all, As the size of my database and the number of users grows, i've found a horrible bug in the system with a very simple solution (but i don't know how to implement it)... If two people...

Microsoft Access / VBA

AccXP Dead Switchboard

by: Baz'noid | last post by:

Hi all, My computer has suddenly decided that it doesn't like the switchboard - it's quite happy to open up on other machines, meaning the database itself isn't at fault, it must be something...

Microsoft Access / VBA

ACC97 on a Network environment

by: amazo | last post by:

Dear all, A new network has been installed on a customer and I get some troubles to do specific things; I will explain: The infraestructure is as follows: .. Server: Windows Server 2003 .....

Microsoft Access / VBA

Passthrough queries and RecordsAffected

by: Bri | last post by:

Greetings, I have a Passthrough Query to SQL Server that I want to know the RecordsAffected, but it always returns 0. This worked perfectly when it was an Access Query on the ODBC linked...

Microsoft Access / VBA

Passthrough connection help

by: hromberg | last post by:

I have a set of passthrough queries that rely on a temporary table in SQL and currently I am dealing with this by creating a passthrough that builds the table and leaves the connection open for an...

Microsoft Access / VBA

MDB server security

by: Murray Chapman | last post by:

Hi A question that I have wanted to ask for ages. Ho do Istop a person from downloading my access database that Iam using as part of my site backend. I am sure that the answer is fairly...

ASP.NET

Updating a server table from a local table

by: rdemyan via AccessMonster.com | last post by:

My application is calculation intensive and the servers are agonizingly slow. Administrators of my application only update the backends once a month (twice a month max). So, my launching program...

Microsoft Access / VBA

script to change passthrough connection string

by: TjS | last post by:

Hellow, i am quite new to access, but i am searching for a visual basic script to change the connection string for all the passthrough queries which are in my access database. These passthrough...

Microsoft Access / VBA

Dlookup issues with Query converted to Passthrough Query

by: RoadrunnerII | last post by:

Hi All I am new to this forum and still learning MS Access. Hoping this is the right place to ask If not please let me know! Looking for some help with the SQL statements in Access 2003 with the...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

AccXP / Acc97 passthrough to SQL Server backend - documentation?

Similar topics