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

Stuart McLachlan stuart.mclachlan at gmail.com
Thu Mar 20 20:20:07 CDT 2014


Create a DDL statement in a pass through query?

"CREATE TABLE ...."



On 20 Mar 2014 at 16:45, Brad Marks wrote:

> Paul,
> 
> I do not have access to GoDaddy's control panel.
> 
> I only have access to the GoDaddy database via ODBC (using Access
> 2007).
> 
> Thanks,
> Brad
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul
> Hartland Sent: Thursday, March 20, 2014 4:44 PM To: Access Developers
> discussion and problem solving Subject: Re: [AccessD] How to Add a New
> Microsoft SQL Server Table using ODBC and Access 2007
> 
> Might be a silly question as you may not have the access, but can you
> not just log onto GoDaddy's control panel, got to the database and add
> it ?
> 
> Paul
> 
> 
> On 20 March 2014 21:20, Brad Marks <BradM at blackforestltd.com> wrote:
> 
> > 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
> >
> 
> 
> 
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> This message was scanned by ESVA and is believed to be clean.
> Click here to report this message as spam. 
> http://h0stname/cgi-bin/learn-msg.cgi?id=BB22828FFF.DFB10
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list