Re: Creating tables

From: Peter E.C Dashwood (dashwood_at_enternet.co.nz)
Date: 10/15/04 

Date: Sat, 16 Oct 2004 02:28:01 +1300

Frederico,

As far as I can tell, it won't do that if you are not using ODBC. (The ODBC
connection decides what SQL is supported...)

See Richard's post in this thread. I believe he is right, but if you have
actually done it, then your straight flush beats our four aces <G>.

My post outlines a way it can be done using DAO and COM/OLE.

Regards,

Pete.

"Frederico Fonseca" <real-email-in-msg-spam@email.com> wrote in message
news:c46om0tkmbivehcgdhr7olf558gd4ksss8@4ax.com...
> On Tue, 12 Oct 2004 11:56:51 +0300, "Dionisis Vrionis"
> <diovr@dksoft.gr> wrote:
>
> >I Have a database named test.mdb without tables.
> >How can i create a table in a database from netcobol.
> >
>
> From MS Acess help
>
> CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH
> COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL]
> [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])
>
> The CREATE TABLE statement has these parts:
>
> Part Description
> table The name of the table to be created.
> field1, field2 The name of field or fields to be created in the new
> table. You must create at least one field.
> type The data type of field in the new table.
> size The field size in characters (Text and Binary fields only).
> index1, index2 A CONSTRAINT clause defining a single-field index.
> multifieldindex A CONSTRAINT clause defining a multiple-field index.
>
>
> You just issue the correct table statement on a SQL connection and it
> will create the table.
>
>
> Frederico Fonseca
> ema il: frederico_fonseca at syssoft-int.com
>

Relevant Pages

  • Re: Using OLEDB from ActiveX DLL
    ... But why use ODBC anyway?). ... It is simply a SQL ... Server Login issue. ... The connection string for OLEDB: ...
    (microsoft.public.vb.general.discussion)
  • Re: how to connect the access to the sql
    ... I go via the ODBC route ... >i know vba code but, ... > but i don't how to write the code to build the link that access to sql ... >> To link in Access to SQL you can use an ODBC connection ...
    (microsoft.public.access.gettingstarted)
  • Re: Data Flow problem - incomplete varchar field
    ... but the data is in a proprietary database and the vendor only provides an ODBC driver to access it. ... What sticks in my craw is that this whole process works just fine on SQL 2000 server, but causes nothing but problems on a SQL 2005 server. ... There must be a way to turn off this "unicode" default so that it will look at the ODBC source and use a DT_STR datatype. ... > there is a way to define the Data Type and size for all input columns. ...
    (microsoft.public.sqlserver.dts)
  • Re: Restrict access to SQL database through ODBC
    ... If the application reports it's name to SQL (which they ... everything that connected to that database of a different application name ... > requires access through an ODBC DSN to my SQL Server ... > run sp_setapprole on that connection. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL Backend w/Access FE using ODBC and Windows Auth Mode
    ... being you have the tables in the access table linked to SQL ... Server via the File based ODBC DSN. ... you can connect to the database right? ... As for the ADO and connection object, they are not options I am familiar ...
    (microsoft.public.sqlserver.setup)