Re: create a new table (ADO)

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/27/05

  • Next message: AlexB: "Re: MSAccess Database protected with password"
    Date: Wed, 26 Jan 2005 19:25:47 -0600
    
    

    >Not, I want to create the any new table.
    >I don't want to save the query rersultset as new table...
    You only have two options for that with Jet. ADOX and SQL DDL Create Table.
    I don't know why you think there is another option but there isn't one.

    --
    Brian Bushay (TeamB)
    Bbushay@NMPLS.com
    

  • Next message: AlexB: "Re: MSAccess Database protected with password"

    Relevant Pages

    • Re: Foreign key with SET NULL: possible?
      ... ADOX is very buggy and inconsistent, but I have that code working in ADOX ... Allen Browne - Microsoft MVP. ... >> JET 4 does support cascade-to-null. ... I'm just trying to establish what Jet does support so that my app ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Table Design
      ... All I said was that I don't know how to use the syntax. ... syntax error and something else about not finding the table or constraint. ... 'CREATE TABLE' syntax, a subset of SQL DDL, has been in Jet since at ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Table Design
      ... · 'CREATE TABLE' syntax, a subset of SQL DDL, has been in Jet since at ... constraints and relationships i.e. avoiding SQL DDL. ...
      (microsoft.public.access.tablesdbdesign)
    • Re: default constraint
      ... But the end result is the same - the combination of ADOX and the ... > SQL Server developers were not, in my opinion, the main target of ADOX. ... SQL DMO would be great - but it doesn't work with Jet at all. ... > GlobalSign digital certificate is a forgery and should be deleted without ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: default constraint
      ... But the end result is the same - the combination of ADOX and the ... > SQL Server developers were not, in my opinion, the main target of ADOX. ... SQL DMO would be great - but it doesn't work with Jet at all. ... > GlobalSign digital certificate is a forgery and should be deleted without ...
      (microsoft.public.vb.general.discussion)