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" <> 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 ~~~
    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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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