| 'The following code shows how to use the data link to open the connection rather than providing the connection 'information directly. Sub ADOUseExistingDataLink() ' Opens an ADO Connection using a Data Links file (UDL) Dim cnn As New ADODB.Connection Dim rs As New ADODB.Recordset cnn.Open "File Name=.\NorthWind.udl;" rs.Open "Customers", cnn, adOpenKeyset, adLockReadOnly rs.MoveLast Debug.Print rs.RecordCount rs.Close cnn.Close End Sub |
Use Existing Data Link |
India web developer web development India | Freelance web development ecommerce web developer | Prayagasoft - web designer India, Ecommerce developer india, Ecommerce design