data1 - Connect via ODBC

[jjferreira]

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

[ande211]

What does your SQL look like? And also if you're using the data control, you can set it's properties at design time. And you don't neccssarily have to do it in code.