sql script

[Paradigm]

Is it possible to run an sql script to add another column to an sql table
from MS Access.
If so how would I do it.
Thanks
Alec

[Terry Kreft]

If you mean to a MS SQL Server table then yes you can do his in a number of
ways.

For exmple you can use
A pass-through query
ADO

With a pass-through query you would
a) create a new query
b) cancel the dialog that appears
c) Choose the Query/SQL Specific/Pass-Through menu otion
d) Open the Query Properties dialog
e) Enter a valid ODBC connection string
f) Enter your ALTER TABLE sql
g) Execute the query

WIth ADO you would do something like

Dim oC as ADODB.Connection
Dim strSQl as string

strSQL = "ALTER TABLE ..."

Set oC = new ADODB.Connection
With oC
.ConnectionString = "Provider=SQOLEDB.1;..."
.Open
.Execute strSQl
.Close
End With
set oC = nothing
--

Terry Kreft
"Paradigm" <al********@hotmail.com> wrote in message
news:Cr******************@newsfe1-gui.ntli.net...

Is it possible to run an sql script to add another column to an sql table
from MS Access.
If so how would I do it.
Thanks
Alec

[Lyle Fairfield]

Paradigm wrote:

Is it possible to run an sql script to add another column to an sql table
from MS Access.
If so how would I do it.
Thanks
Alec

http://msdn2.microsoft.com/en-us/library/ms190273.aspx

[Paradigm]

Thanks
What references do I need for ADO
Alec

"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:Yc********************@karoo.co.uk...

If you mean to a MS SQL Server table then yes you can do his in a number of ways.

For exmple you can use
A pass-through query
ADO

With a pass-through query you would
a) create a new query
b) cancel the dialog that appears
c) Choose the Query/SQL Specific/Pass-Through menu otion
d) Open the Query Properties dialog
e) Enter a valid ODBC connection string
f) Enter your ALTER TABLE sql
g) Execute the query

WIth ADO you would do something like

Dim oC as ADODB.Connection
Dim strSQl as string

strSQL = "ALTER TABLE ..."

Set oC = new ADODB.Connection
With oC
.ConnectionString = "Provider=SQOLEDB.1;..."
.Open
.Execute strSQl
.Close
End With
set oC = nothing
--

Terry Kreft
"Paradigm" <al********@hotmail.com> wrote in message
news:Cr******************@newsfe1-gui.ntli.net...

Is it possible to run an sql script to add another column to an sql table from MS Access.
If so how would I do it.
Thanks
Alec

[Terry Kreft]

Microsoft ActiveX Data Objects x.x Library

Replace x.x in the above line with the version number.

--

Terry Kreft
"Paradigm" <al********@hotmail.com> wrote in message
news:ix******************@newsfe1-gui.ntli.net...

Thanks
What references do I need for ADO
Alec

"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:Yc********************@karoo.co.uk...

If you mean to a MS SQL Server table then yes you can do his in a number

of

ways.

For exmple you can use
A pass-through query
ADO

With a pass-through query you would
a) create a new query
b) cancel the dialog that appears
c) Choose the Query/SQL Specific/Pass-Through menu otion
d) Open the Query Properties dialog
e) Enter a valid ODBC connection string
f) Enter your ALTER TABLE sql
g) Execute the query

WIth ADO you would do something like

Dim oC as ADODB.Connection
Dim strSQl as string

strSQL = "ALTER TABLE ..."

Set oC = new ADODB.Connection
With oC
.ConnectionString = "Provider=SQOLEDB.1;..."
.Open
.Execute strSQl
.Close
End With
set oC = nothing
--

Terry Kreft
"Paradigm" <al********@hotmail.com> wrote in message
news:Cr******************@newsfe1-gui.ntli.net...

Is it possible to run an sql script to add another column to an sql table from MS Access.
If so how would I do it.
Thanks
Alec