Modify SQL 2005 table from Access 2007

  • Thread starter Thread starter TJ Dowling
  • Start date Start date
T

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
 
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
 
Back
Top