[AccessD] How to Add a New Microsoft SQL Server Table using ODBC and Access 2007

Brad Marks BradM at blackforestltd.com
Thu Mar 20 16:20:25 CDT 2014


All,

For several years, I have worked with a Microsoft SQL Server database
that is tied to our website (Hosted by GoDaddy).  A web guru in another
city has designed the website, database, etc.  My role has been to
simply pull data from this database.

Now, as part of some "Back Office streamlining", we would like to add
one new table to this existing database.

I have never added a new table to Microsoft SQL Server from Access 2007.
What is the best way to do this?

I have worked with IBM's DB2 DDL in a prior life but not with SQL Server
DDL.

Thanks,
Brad




More information about the AccessD mailing list