Results 1 to 2 of 2

Thread: DAO data1 - connection

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    127
    Dear all at the moment I'm connecting to a db using the code below and the data component, normally
    called data1.

    I have been trying to conect to another db but this time using OBDC, but this time without success, also
    I'm using DAO 3.6.

    =============== Current Code ==================
    Data1.DatabaseName = "c:\windows\desktop\mydb.mdb"
    Data1.Connect = Access
    Data1.RecordSource = Me.txtSQL.Text
    ' We make the results visible
    DBGrid1.Visible = True
    Data1.Refresh
    ASPWIZARD

    http://www.aspwizard.co.uk

  2. #2
    Addicted Member LAURENS's Avatar
    Join Date
    Jan 2000
    Location
    Utrecht, the Netherlands
    Posts
    138
    At a first glance I'd say
    Data1.connect = Access
    needs quotes.
    Data1.connect = "Access"

    I trust the grid is linked to the datacontrol?

    Regards,
    Laurens

    Using VB5 Enterprise edition SP3
    VB6 Enterprise edition SP5

Posting Permissions

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



Click Here to Expand Forum to Full Width