[AccessD] Pass Trough Query to SQL Server

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Mon Sep 26 10:38:38 CDT 2005


Chester,

In Access 97:
If you go into design view of the table in question, then view the table
properties (View menu, Properties option).  The Description line in the
properties box shows the connection properties of the table including the
table/view you are connected to.  I find it helpful to open a Zoom window on
that line (Shift+F2 when it is selected).

Another way is to view the system tables (Tools menu, Options option, View
tab, click on System Objects).  The MSysObjects table will have a Connect
column with the same database connection information then the ForeignName
column tells the table/view.

You can only view the information in these places, you can't change the
settings.

HTH

Rusty

-----Original Message-----
From: Kaup, Chester [mailto:Chester_Kaup at kindermorgan.com]
Sent: Monday, September 26, 2005 9:54 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Pass Trough Query to SQL Server


Thanks for the help. That got the query to work. I should have checked
into SQL server data types. That's what happens when engineers put me
outside my comfort zone. 

Now another question if I may.
Is there a way to tell if a SQL server or Oracle link is to a table or a
view?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Barash
Sent: Monday, September 26, 2005 9:44 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Pass Trough Query to SQL Server

There is no data type DOUBLE in SQL Server. Try changing that to float. 

James Barash

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Monday, September 26, 2005 10:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Pass Trough Query to SQL Server

You are correct I don't need the word COLUMN. Also found an error with a
space before 05. Took out the space. Now get an error of incorrect
syntax near ;. Removed the ; and get a message of incorrect syntax near
DOUBLE.
Persistence will prevail. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, September 26, 2005 9:17 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Pass Trough Query to SQL Server

It's possible that you don't need the keyword COLUMN but why don't you
try
running the statement in Query Analyzer and see what kind of error you
get
-- might be a more helpful message. Just a thought. 

Susan H. 


ALTER Table dbo_Sharon_Ridge ADD COLUMN SR_CO2_Sep_ 05 DOUBLE

 

I get the following message when I try to run the query

ODBC - call failed

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'COLUMN'. (#156)

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list