I am trying to set the value of the connection string property. My data is not in Access, it is in SQL Server, I'm just using Access to develop a front end.
I have been following a text book, but when I follow their example, it does not work. I created a button, and an afterclick event handler for it. See below, it is the assignment statement for sConn that doesn't work.
Private Sub Command3_Click()
Dim adConn As ADODB.Connection
Dim sConn As String
Set adCon = New ADODB.Connection
sConn = "Provider=SQLOLEDB.1;Integ
rated Security=SSPI;Persist Security Info=False; Initial Catalog=DATA_CONCEPTS;Data
adConn.ConnectionString = sConn
Set adConn = Nothing