Modify SQL 2005 table from Access 2007

[TJ Dowling]

I need to modify a SQL 2005 table by adding a new field. Is there a tool
that I can do that from Access 2007?

I use Access 2007 as the front-end with ODBC links to SQL 2005 tables. It
would be easier for me if I could just modify the table structure from Access.

Thanks,
TJD4

 

[Tom van Stiphout]

On Wed, 10 Dec 2008 16:11:01 -0800, TJ Dowling

The easiest way is if you have an Access ADP. Then you can do this in
a table designer.
With an MDB, you may need to issue an ALTER TABLE statement in a
passthrough query.

-Tom.
Microsoft Access MVP

 

[TJ Dowling]

The ALTER TABLE statement in a pass-thru query worked.

Thanks,
TJD4