-
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
-
At a first glance I'd say
Data1.connect = Access
needs quotes.
Data1.connect = "Access"
I trust the grid is linked to the datacontrol?