Creating Database Access 97 with VS 2005 RRS feed

  • Question


    Hello people!


    First, Sorry because my english is bad, I am studing the language.


    Second, my problem is:


    I will have create the database Access 97 with VS 2005.

    I try using the dll: Microsoft ADO Ext. 2.8 for DDL and Security


    My code is:

    Public Sub CreateDatabase

    Dim catalogo As Catalog = New Catalog()

     m_sConex = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & local_arq & "\" & name_arq

     catalogo.Create(m_sConex )

     dbFactory = New Utilitys.Factory(m_sConex , TipoDB.OLEDB)

    End Sub


    It created one database but in version 2000 and I need in version 97.


    How Can I create the database ???

    What is dll for use???


    Again, sorry because my english, I am Brazilian  ...


    Thank you so much for answers.





    Monday, August 13, 2007 5:17 PM


  • Try adding the following argument to your connection string:


    Jet OLEDB:Engine Type=4



    Monday, August 13, 2007 6:23 PM