Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    24

    Lightbulb Unanswered: Download Access ODBC Driver

    I am developing an application using Access as a back end DB

    I believe it is possible to connect to an Access DB even if Access is not install, but you do need the Access ODBC Driver install. This comes standard with Ofice Pro but can i download it from anywhere ????

    I've looked at Microsofts Download Site buit can't find what i want

    please help

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Download Access ODBC Driver

    Originally posted by m.inckle
    I am developing an application using Access as a back end DB

    I believe it is possible to connect to an Access DB even if Access is not install, but you do need the Access ODBC Driver install. This comes standard with Ofice Pro but can i download it from anywhere ????

    I've looked at Microsofts Download Site buit can't find what i want

    please help
    Look for MDAC .... It's there.

  3. #3
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: Download Access ODBC Driver

    That is correct you do not need Access installed to access an Access database.

    Here is where you can download MDAC (ADO)
    http://download.com.com/3150-2404-0.html?tag=stbc.gp

    Here is some code to connect to an Access database, retrieve data from Table1, close the recordset and close the connection using Visual Basic with ADO:

    Dim cn as ADODB.Connection
    Dim rs as ADODB.Recordset

    Set cn = new ADODB.Connection

    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Test.mdb;Persist Security Info=False"

    cn.open

    set rs = new ADODB.recordset

    rs.ActiveConnection = cn

    rs.Open "SELECT * FROM Table1"

    rs.Close

    cn.Close

    Set rs=Nothing
    Set cn = Nothing
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •