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

Depending on which version of SQL Server your Godaddy site is using you
could attach to the database using SQL Server Management Studio and create
the table through that interface. If your hosting account does not offer
that capability you can use the SQL Server interface available through your
Godaddy web database management interface. You can get to that by logging
into your Godaddy hosting account. I have pretty much moved all the sites we
work with away from Godaddy so it has been a couple of years since I have
used that interface. In either case you don't have to use DDL.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, March 20, 2014 2:20 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Add a New Microsoft SQL Server Table using ODBC
and Access 2007

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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com