Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Post Unanswered: Is this possible?

    I am a new user to visual basic 6. Can I access Access files(*.mdb) using visual basic 6.0 using ADO jet engine without having Access installed on my computer.
    Can anyone help me out?

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Yes you can. You do not need Access installed on your machine to access *.MDB files using VB and ADO.

    Here is some sample code:

    Code:
    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;Password=TestPass;Data Source=C:\Test.mdb;Persist Security Info=False;Exclusive=0"
    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!

  3. #3
    Join Date
    Jun 2004
    Posts
    5
    Thanks SCIROCCO

Posting Permissions

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