ADO + Access mdb file


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO + Access mdb file

  1. #1
    Diogo Piolho Guest

    ADO + Access mdb file


    How do I create an mdb access file via ADO ???



  2. #2
    Paul Clement Guest

    Re: ADO + Access mdb file

    On 20 Feb 2001 16:13:31 -0800, "Diogo Piolho" <diogo@infernal.com.br> wrote:


    How do I create an mdb access file via ADO ???


    I would use ADOX (ActiveX ADO Ext. for DDL and Security) instead:

    Sub CreateAccessWithADOX()

    Dim tbl As New ADOX.Table
    Dim col As New ADOX.Column
    Dim cat As New ADOX.Catalog

    'Engine Type=4 is Access 97 and a value of 5 is Access 2000
    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\My Documents\TestDB.mdb;" & _
    "Jet OLEDB:Engine Type=4;"

    tbl.NAME = "NewTable"
    col.NAME = "Column1"
    col.Type = adLongVarWChar
    tbl.Columns.Append col
    cat.Tables.Append tbl

    Set cat = Nothing

    End Sub


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center