[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